Discussion Board for collaboration related to QlikView App Development.
I would like to conditionally turnoff totals on a straight table, can this be done at all ?
A table lists 4 rows , each row is by country and aggregated sales ... user selects rollup to a specific currency e.g. AUD$,
to the grand total of the 4 rows is in AUD and each row is converted to the select currency , however the user now selects
local currency, i.e each row total is in the local $ e.g. Canada, US , Aus etc.
The problem is the grand total is now summing different currencies, this is not desirable of course.
I cant find anyway that will allow me to conditionally switch off the Grand Totals when the user selects 'Local Currency' option.
Is there a chart property I can get access to in a script expression that will allow me to achieve this?
Thanks in advance
Pivot table Is impractical in this instance as it will result in the incorrect format the user wants to see. I still need totals but only when a common currency is selected.
Create 2 charts one with the total and another without total and then show and hide the charts based on the condition using Layout tab -> Show Conditional option.
Hope this helps you.
I have created a sample application as per your requirement.
For Straight Table : I have added two expression. And Enabled expression total for one of the dimension. On click of a button I have Enabled one of the expression and hide the other one
For Pivot Table: I have added the same dimension twice. And Enabled Partial sums for one of the dimension. On click of a button I have Enabled one of the dimension and hide the other one
Make use of this and change the condition based on the currency selection...
Hop[e this helps you
Hi Prabhu, Many thanks for your reply, this is a good idea, but the problem is that when many fields (in my case 15 fields) are displayed I would need to duplicate these , thanks anyway.
Further Notes .. thanks to everyone who has contributed so far, great efforts ...
Currency Options : $AU | $NZ | Local
Country Sales Summary
Country Item SalesLY SalesTY
$450 $625 <<<< Expression total , I want to hide this when local currency selected as summing on disparate currencies is incorrect
US Chips $US100 $US125
CAnada Chips $CA200 $CA225
NZ Chips $NZ100 $NZ175
AU Chips $AU50 $AU100
If the user selects the Currency to report all countries in, then they can choose $AU or $NZ then all sales totals are
converted to the reporting currency selected, then I expect the totals to display.
It would be great if QV supported conditional display of the Expression Total option i.e. Switch 'No Totals' or 'Exp Total' etc.