Conditional Total (show and hide option)

aniruddha_sinha — Fri, 15 Nov 2024 21:17:17 GMT

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!

Re: Conditional Total (show and hide option)

VatsalyaSolanki — Tue, 31 Oct 2023 12:13:00 GMT

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/BasicAggregationFunctions/only.htm

Re: Conditional Total (show and hide option)

aniruddha_sinha — Sun, 05 Nov 2023 19:53:46 GMT

Thanks Vatsal.

topic Re: Conditional Total (show and hide option) in App Development

Conditional Total (show and hide option)

Re: Conditional Total (show and hide option)

Re: Conditional Total (show and hide option)