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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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

1 Reply
consenit
Partner - Creator II
Partner - Creator II

Hi there.

See QVW attached.

Kind regards,

Ernesto.