Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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

View solution in original post

2 Replies
Gysbert_Wassenaar

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
Author

fantastic! thanks for the trick