Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

customize Pivot table

Hi all,

i have pivot table like below but i need to show extra one row with blue color based on Dim-3 how can i achieve this requirement?

Actual

1.png

what we need

2.png

please give some idea...

16 Replies
Highlighted

Check attached

Capture.PNG

Highlighted
Creator
Creator

thanks, Sunny

i have face the following issue 

3.png

Highlighted

Uncheck 'Suppress Zero Value' on the presentation tab and see if that helps

Highlighted
Creator
Creator

i made changes in following things

Dim3

=Pick(ExtraDim, if([FINANCIAL PLAN]<>'ZZZZZ',[FINANCIAL PLAN]), ' ')

Dim3 color

=If(ExtraDim = 2, LightBlue())

expression

Pick(ExtraDim, (if ([FINANCIAL PLAN] <>'ZZZZZ', SUM(AMOUNT),0)), 0)

expression color

=If(ExtraDim = 2, LightBlue())

sort

Only({1} ExtraDim)

Highlighted

Uncheck 'Suppress Zero Value' on the presentation tab and see if that helps

Highlighted
Creator
Creator

Sunny,

i have Unchecked Suppress Zero Value, it does not work.

FYI -->  by default following selection will happen, when i clear all it's working fine.

5.png

4.png

Highlighted
Creator
Creator

Sunny

Even i clear all selection but i facing the same issue (Suppress Zero Value Unchecked)

6.png

Highlighted

May be try this

Dim3

=Pick(Only({1} ExtraDim), if([FINANCIAL PLAN]<>'ZZZZZ',[FINANCIAL PLAN]), ' ')

Dim3 color

=If(Only({1} ExtraDim) = 2, LightBlue())

expression

Pick(Only({1} ExtraDim), (if ([FINANCIAL PLAN] <>'ZZZZZ', SUM(AMOUNT),0)), 0)

expression color

=If(Only({1} ExtraDim) = 2, LightBlue())

Highlighted
Creator
Creator

Error In Calculated Dimension