Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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
Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

8 Replies
Highlighted
Partner
Partner

Remove all dimensions from your table and keep only the expressions. It should give you what you want.
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Creator II
Creator II

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

Highlighted
Partner
Partner

Use a KPI object if you dont want any dimensions
Highlighted
Creator II
Creator II

Hi Dilipranjith,

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

Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted
Creator II
Creator II

This is helpful. Thanks!

Highlighted
Creator II
Creator II

Worked! Thanks!