Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikapple
Creator
Creator

new to qlikview

HI All,

I have pie chart  wit level3 as dimension and expression as

NUM(Count(Id)/count(Total Id), '#,##0%')

 

I dot want to show the zero% in the chart . please find the screen shot below. please help

 

 

Capture123.PNG

Labels (1)
1 Solution

Accepted Solutions
TiagoCardoso
Creator II
Creator II

Hi,

Maybe

IF(Count(Id)/count(Total Id) > 0,

            NUM(Count(Id)/count(Total Id), '#,##0%'))

View solution in original post

5 Replies
TiagoCardoso
Creator II
Creator II

Hi,

Maybe

IF(Count(Id)/count(Total Id) > 0,

            NUM(Count(Id)/count(Total Id), '#,##0%'))

qlikapple
Creator
Creator
Author

please help 

 

qlikapple
Creator
Creator
Author

hi

qlikapple
Creator
Creator
Author

please help

TiagoCardoso
Creator II
Creator II

Ops...

tiagocardoso_0-1597159913022.png

 

tiagocardoso_1-1597160027822.png

Sorry for my English.

Please click with the right button and export the data of this pie chart to excel and attach it here so I can simulate the load of this chart and be able to help you better.