Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.