I am new in the Qlikview tool, I have straight table where grid rows calculation has sum calculated measures but in the "Totals" don't want the sum of the measures in my grid rows. But need apply the new calculation. Is it possible and how can we do it. Since don't find any custom totals in the table properties.
Thanks, in advance.
What is "the new calculation" you're trying to apply for the 'Total'?
Would a pivot table work better for you or do you need a straight table for your end goal?
You can use a statement like:
if(dimensionality()=0, avg(Value), sum(Value))
where avg(Value) would be the expression for your total.
Please find attached.
Hope this helps!
I am uploading the QVW. SO I have two List box in the sheet. If user select first one BU LVL1 I have different calculation, like remove the one of the column in sum I am doing but in straight table has BU LVL 2 description so that it using different calculation but the total is actually for all BU LVL2 . So it has to calculate at BU LVL 1 so need different calculation.
Why dont you keep both the dimensions in the chart and enable/disable them based on selections?
So if BU LVL1 is selected, the chart will have BU LVL1 as the active dimension and also Total up based on that dimension.
Would that help or am I missing something?