Qlik expression to DAX expression conversion

Question

I need help in converting Qlik sense expression into a DAX expression.

Qlik sense expression:

if(sum(Total <AssociateEmail,RatingManager>{<flag_skill={1}>}RatingManager)>0, 'Initiated', 'Not Initiated')

AssociateEmail -- is from Table A
RatingManager,flag_skill -- is from Table B

pls provide some sample data and expected output

Ryan
– Ryan

2024-09-26 01:11:24 +00:00
Commented Sep 26, 2024 at 1:11 — Ryan
– Ryan, Commented Sep 26, 2024 at 1:11

Nick A · Accepted Answer · 2024-09-26 13:01:36Z

0

The DAX expression:

IF(
    CALCULATE(
        SUM('Table B'[RatingManager]),
        'Table B'[flag_skill] = 1,
        ALLEXCEPT('Table A', 'Table A'[AssociateEmail])
    ) > 0,
    "Initiated",
    "Not Initiated"
)

answered Sep 26, 2024 at 13:01

Nick A

1,1202 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Sri Harsha Over a year ago

Thank you .. one doubt , why did you use all except function only for associate email field

Nick A Over a year ago

It keeps the context of that column and removes filters from all other columns. You can delete that line if you'd like.

Sri Harsha Over a year ago

Thank You ... Can you help me with below Qliksense expression "" if(sum(Total <AssociateEmail>{<Priority-={''},flag_skill={0}>}[MSL/Med Name])>0 , 'Completed', if((sum(Total <AssociateEmail>{<Priority-={''},flag_skill={0}>}[MSL/Med Name])>0 or sum(Total <AssociateEmail>{<RatingSelf-={''},flag_skill={0}>}[MSL/Med Name])>0 ), 'Initiated', 'Not Initiated')) "" where Associateemail and Medname are coming from Tab1 and Ratingself, flagskill, priority coming from Tab2

Nick A Over a year ago

I recommend you post that as a new question and accept this answered. This will bring your new question to a larger audience.

Collectives™ on Stack Overflow

Qlik expression to DAX expression conversion

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related