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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use a self created measure as dimension?

Hi everyone,

I have created an expression to calculate something ,now can I do some more calculation on the same expression?

Example:

count(if(abc=0,id))

and named it as  "#ids"

Now, can I do

count(if(#ids >1, 'A','B'))

and I want to use this in pie chart.

Pls help on this.

Thanks

Shivesh

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Perhaps thuis:

=count(Aggr(if(count(if(abc=0,id)) >1, 'A','B'), <...pie chart dimension here...>))

I suggest that you post a sample qvw to save the guesswork and ensure that you get accurate and useful suggestions.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
sunny_talwar
MVP
MVP

I agree it would be easier to troubleshoot with a handy sample