Discussion board where members can learn more about Qlik Sense App Development and Usage.
I want to create a pivot table looking like this:
Dimensions: country, pass_fail_status
Expessions: count(id). count(id2)
Any idea how to achieve this?
I'm able to show one expression only. If I add the second expression, it becomes two tables.
I also tried using normal table, which solved the problem, but the presentation is not nice. The country names will show twice.
Go to Solution.
You'll have to use a trick for it for now with a synthetic dimension =ValueList('Count 1','Count 2') and one expression =If(ValueList('Count 1','Count 2')='Count 1', count(id), count(id2) )
fantastic! thanks for the trick