Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use calculation condition in chart

Could you give me some sample to add calculation condition in chart?

Thanks.

1 Solution

Accepted Solutions
Not applicable
Author

I remember using 'calculation condition' when I wanted a chart to display the employee count where i never wanted comployees with grade as 'cwr' to be included.

I gave something like =(EMP_TYPE<>'CWR') in calculation condition then and then the chart would display the measures for all other emp types except 'CWR'

View solution in original post

2 Replies
Not applicable
Author

I remember using 'calculation condition' when I wanted a chart to display the employee count where i never wanted comployees with grade as 'cwr' to be included.

I gave something like =(EMP_TYPE<>'CWR') in calculation condition then and then the chart would display the measures for all other emp types except 'CWR'

brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

I do not understand, what you mean, maybe:

Sum({<Field1={"Value1"}>} If(Field2>Value2,Field3,Field4))