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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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