Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Expression logic

Hi All, 

I am using a pivot table and in calculated dimension I am using below expression

Aggr(If(PTG=PT,'G','R'),Product)  which is giving the desire output .. 

But I   need to pass the below expression into the above calculated dimension 

Count({<sev-={'5'}>}ID)

I am really stuck with this need your help 

Thanks in Advance 

John

Labels (5)
4 Replies
MarcoWedel

please explain your requirement using some sample data and your expected result as well.

smilingjohn
Specialist
Specialist
Author

Thanks for the reply @MarcoWedel 

Basically I am trying to show a column in pivot table with 'G'(Green) and 'R'(Red)  . below is my table 

smilingjohn_0-1655589101189.png

Here I am  using calculated dimension as     Aggr(If(PTG=PT,'G','R'),Product) hence getting the above out put 

and I have a Expression as  Count({<sev-={'5'}>}ID) 

My above calculated dimension should pass the other considering the expression within it .

To achieve this I am tried this below logic and this show expression is okay but doesn't work properly 

=aggr(if(PGT=PT and Count({<sev-={'5'}>}ID) >0,'G','R'),Product)

Hence seeking help to know how can I include the expression  within the calculated expression  to make output work properly  

Thanks

 

 

 

smilingjohn
Specialist
Specialist
Author

Hi all 

Any help on my post 

smilingjohn
Specialist
Specialist
Author

Tried with all the possibilities but not able to achieve the expression .