Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Straight table chart with customized rows.

I am trying to create a straight table which has an added row showing the subset of the top rows filtered by Geo. I am trying to show the product and its quantity sold with an additional row showing just the canadian number. I tried using a calculated dimension with if(geo='Canada', 'Canada', Product) obviously I don't get the result I expect to see.

Expected Result:

ProductQuantity
A1
B2
C3
Canada2

Result Obtained:

ProductQuantity
A1
B1
C2
Canada2

Any help is appreciated.

Thank you

Suraj

Labels (1)
1 Reply
consenit
Partner - Creator II
Partner - Creator II

Hi there.

See QVW attached.

Kind regards,

Ernesto.