How to hide details and only show total in QlikSense straight table?

[wanyunyang]

Hi guys,

I have a straight table: aging by customer. The rows are customers; And the columns are 30 days aging, 60 days aging, 90 days aging, etc.. I would like to show Totals only, and hide details of each customer. Is it possible to do so?

Thanks in advance!

[Vegar]

Remove all dimensions from your table and keep only the expressions. It should give you what you want.

[wanyunyang]

Hi Vegar, I gave it a go, it asked for one dimension at least. 

[dplr-rn]

Use a KPI object if you dont want any dimensions

[wanyunyang]

Hi Dilipranjith,

But KPI chart can only show two numbers at most. I would like to show all my numbers in one chart.

[dplr-rn · Accepted solution]

Ah.. ok. good to know. So you want multiple measures listed just totals.
you need value list concept it will fulfill your requirement (it can be very powerful for complex requirements too)

create calculated dimension
=ValueList('KPI #1','KPI #2')
measure
=IF( ValueList('KPI #1','KPI #2')='KPI #1,',
Sum([KPI #1 Field],
Count([KPI #2 Field])
)

more details see below


https://community.qlik.com/t5/Qlik-Design-Blog/ValueList-For-those-tricky-situations/ba-p/1476275

[Vegar · Accepted solution]

@wanyunyang I see, I'm mixing Qlik Sense functionality in QlikView.

Try this instead. Wrap your expression with an if statement.

=If(Dimensionality( )= 0 , YourExpression, null())

[wanyunyang]

This is helpful. Thanks!

[wanyunyang]

Worked! Thanks!