topic Re: Straight Table - Total need custom total in QlikView

Straight Table - Total need custom total

Tue, 16 Sep 2014 16:33:22 GMT

Hello,

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.

Re: Straight Table - Total need custom total

ecolomer — Tue, 16 Sep 2014 16:50:57 GMT

Can you upload file QV ?

And explain more details that you need, please.

Re: Straight Table - Total need custom total

yogiachilleos — Tue, 16 Sep 2014 18:02:20 GMT

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?

Re: Straight Table - Total need custom total

sundarakumar — Tue, 16 Sep 2014 18:05:59 GMT

We have some predefined options... It cannot be customized..

Hope this helps.

-Sundar

Re: Straight Table - Total need custom total

jerem1234 — Tue, 16 Sep 2014 19:57:41 GMT

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!

Re: Straight Table - Total need custom total

Wed, 17 Sep 2014 04:08:11 GMT

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.

Re: Straight Table - Total need custom total

Wed, 17 Sep 2014 04:15:58 GMT

please upload the QVW file

Re: Straight Table - Total need custom total

Wed, 17 Sep 2014 04:27:26 GMT

Hi Viral,

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?

Re: Straight Table - Total need custom total

sreenivas123 — Wed, 22 Feb 2017 13:19:07 GMT

please upload example .qvw file!