Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
laddu_927
Specialist
Specialist

One aggregated row when no filter is selected.

Hi All,

Build a pivot table samething like below

               Month Month1   Month2  Total

dimension 

A                        10               20          30

B                         20               30          50

C                          30               40          70

is when i have no selection on filter "dimension".

and  shows respective A, B, C values when a value is selected in filter.

Here when no filter is selected,

I want My table look like

               Month Month1   Month2  Total

dimension 

ALL                        60               90          160

Please help.

1 Solution

Accepted Solutions
sunny_talwar

May be use a calculated dimension like this

If(GetSelectedCount(Dimension) = 0, 'ALL', Dimension)

View solution in original post

1 Reply
sunny_talwar

May be use a calculated dimension like this

If(GetSelectedCount(Dimension) = 0, 'ALL', Dimension)

View solution in original post