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: 
wanyunyang
Creator III
Creator III

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

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!

2 Solutions

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

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

View solution in original post

Vegar
MVP
MVP

@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())

 

View solution in original post

8 Replies
Vegar
MVP
MVP

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

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

dplr-rn
Partner - Master III
Partner - Master III

Use a KPI object if you dont want any dimensions
wanyunyang
Creator III
Creator III
Author

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
Partner - Master III
Partner - Master III

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
MVP
MVP

@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
Creator III
Creator III
Author

This is helpful. Thanks!

wanyunyang
Creator III
Creator III
Author

Worked! Thanks!