topic Re: Conditional count in Bar chart in QlikView

Conditional count in Bar chart

Thu, 08 May 2014 06:11:00 GMT

Hi I have a table show above. And I would like to show the data in a bar chart that

(if([English Grade]='A' and '[Math Grade]'='A', count(Name))

But I just type the above expression, the chart shows nothing. What should I modify in the expression that I could get the number I want?

Thanks so much!

maxgro — Thu, 08 May 2014 06:14:58 GMT

in bar chart

dimension Name

expression count(if([English Grade]='A' and [Math Grade]='A', Name))

ferha_jafri — Thu, 08 May 2014 06:18:42 GMT

Try this,

(if([English Grade]='A' and '[Math Grade]'='A', substringcount(Name,Name))

Thu, 08 May 2014 06:23:38 GMT

Yes! It looks good now. Thanks so much!

PradeepReddy — Thu, 08 May 2014 06:37:00 GMT

we can achieve this using set analysis also...

count({$<[English Grade]={'A'},[Math Grade]={'A'}>}Name)