Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am attempting to make a stacked bar chart, but I am having difficulty in appropriately doing a Count IF. The two Count IFs I need to do are Count IF = 'Pass' and Count IF = 'Fail'.
If I understand correctly Qlik does not support the COUNTIF function, but I still can not seem to get the syntax correct to get the appropriate answer
Try
=count({<Your Dimension={'Fail'}>} Your Dimension)
=count({<Your Dimension={'Pass'}>} Your Dimension)
or for both
=count({<Your Dimension={'Pass','Fail'}>} Your Dimension)
You didn't say what you wanted to count or the field name containing the Pass/Fail text.. Try:
count({$<YourPassFailField = {'Pass'}>} FieldToCount)
count({$<YourPassFailField = {'Fail'}>} FieldToCount)
Try
=count({<Your Dimension={'Fail'}>} Your Dimension)
=count({<Your Dimension={'Pass'}>} Your Dimension)
or for both
=count({<Your Dimension={'Pass','Fail'}>} Your Dimension)
Oh that was not my expression in the original post merely my thought process. I simply want to count the number of 'Pass' and 'Fail' separately to create a stacked bar chart.
I apologize for my poor explanation.