Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Straight Table - Total need custom total

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.

8 Replies
ecolomer
Master II
Master II

Can you upload file QV ?

And explain more details that you need, please.

TX

yogiachilleos
Contributor III
Contributor III

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?

sundarakumar
Specialist II
Specialist II

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

total.png

Hope this helps.

-Sundar

jerem1234
Specialist II
Specialist II

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!

Not applicable
Author

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.

Not applicable
Author

please upload the QVW file

Not applicable
Author

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?

SK

sreenivas123
Contributor
Contributor

please upload example .qvw file!