Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
guruprem
Contributor III

Hiding specific column Totals in Qlik Sense table

Hi,

I created a simple table as shown below, I need totals for some columns , for some other columns I do not need totals, how can I achieve this.

IN following example I do no wanna show any totals in "Final Profit or Loss %" column, I tried selecting "None" in Totals Function of this column still Qlik is showing something. Please help.

Hiding Column in Qlik Sense.PNG

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Hiding specific column Totals in Qlik Sense table

Try using the Dimensionality() function.

Change your expression from something like =sum(X) to =If(Dimensionality()>0, sum(X))


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: Hiding specific column Totals in Qlik Sense table

Try using the Dimensionality() function.

Change your expression from something like =sum(X) to =If(Dimensionality()>0, sum(X))


talk is cheap, supply exceeds demand
jayaseelan
Contributor III

Re: Hiding specific column Totals in Qlik Sense table

Hi,

Try this

If(Dimensionality()>0, sum(Final Profit or Loss %),'')

Which gives empty in the place of total.

Thanks,