Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Chart - Triangle

I want to use qlikview to show pivot chart like below to show experience. Basically,  for year 2016, the experience of Yr1 is unknown, and I have 0s now in the current display. I want it show as blank, or "-" for the unkown experience. Is there any way I can do it?   

Iss PeriodCancYr 1Yr 2Yr 3Yr 4Yr 5
201110.2%96.9%101.7%124.0%114.3%91.7%
20129.9%89.7%121.1%108.0%97.4%
20138.7%111.3%99.9%86.9%
20149.1%109.1%109.7%
2010511.2%106.8%
201617.3%
1 Solution

Accepted Solutions
varshavig12
Specialist
Specialist

May be something like:

if(Field_name=0,' ',Field_name)

View solution in original post

2 Replies
varshavig12
Specialist
Specialist

May be something like:

if(Field_name=0,' ',Field_name)

qlikview979
Specialist
Specialist

Hi ,

DO you want like this

load * Inline [

Iss Period, Canc, Yr 1, Yr 2, Yr 3, Yr 4, Yr 5

2011, 10.2%, 96.9%, 101.7%, 124.0%, 114.3%, 91.7%

2012, 9.9%, 89.7%, 121.1%, 108.0%, 97.4%,    ,

2013, 8.7%, 111.3%, 99.9%, 86.9%, ,        ,

2014, 9.1%, 109.1%, 109.7%, ,   ,        

2010, 511.2%, 106.8% , ,    ,   ,      

2016, 17.3%,        ,      ,       ,    ,   ,    

];

];

Diemension:-Iss Period

Expression:-

if(Canc=0,' ',Canc)

if(Yr 1=0,' ',Yr 1)

if(Yr 2=0,' ',Yr 2)

if(Yr 3=0,' ',Yr 3)

if(Yr 4=0,' ',Yr 4)

if(Yr 5=0,' ',Yr 5)


Goto Sort Tab check the Expression Write like this

=Match([Iss Period],2011,2012,2013,2014,2010,2016)





Untitled.png