Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
faridguliyev97
Contributor
Contributor

NEW DIMENSION WITH NEGATIVE NUMBERS OR COMPARISON

Hello Guys, I am trying to make a new dimension and condition is like that,

=if(sum(cost) >sum(totalConvValue)) AND keywordState = 'enabled', keyword)

 

I would like to choose negative keywords and show them in another table. Additionall I could not find count of negative and positive keywords. For example, it gives count of total enabled keywords but does not show conditional count.

 

Count({$<keywordState = {'enabled'}, cost > totalConvValue>}keyword)

 

 

0 Replies