Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Two expressions in pivot table row by row

I want to create a pivot table looking like this:

Capture.JPG

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.

Tags (1)
1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: Two expressions in pivot table row by row

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) )


talk is cheap, supply exceeds demand
2 Replies
Gysbert_Wassenaar
Not applicable

Re: Two expressions in pivot table row by row

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) )


talk is cheap, supply exceeds demand
Not applicable

Re: Two expressions in pivot table row by row

fantastic! thanks for the trick