Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. 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