Conditional Total (show and hide option)

[aniruddha_sinha]

Hi,

I have a table chart showing  Sales_person_id, Date_of_Sales, Sales_Amount, Sales_Currency columns.

I get this report generated via qlik ODAG, so at a time one report will have only one sales_person_id showing that sales person's all sales through out the years in different currencies (occasionally).

Most of the cases, one sales_person_id will have same sales_currency, but there are exceptions where one sales person sold in different currencies over the time.

I want to show the Total row at the top of the table like we show in qlik table chart, BUT Total value will show the total of Sales_Amount ONLY WHEN that table chart contain one single currency value.

If, that table has multiple distinct sales_currency value, the Total row will disappear.

Can anyone please help on the same.

Thanks much!

[VatsalyaSolanki · Accepted solution]

Hey @aniruddha_sinha ,

Did you try using the Only function.

If not go through the page below,

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/BasicAggre...

[aniruddha_sinha]

Thanks Vatsal.