Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Percentage is showing zero after clicking on clear button

Hi ,

I have created pivot table. Where i have 2 fields name and Percentage.

I am trying to give different colors as per percentage.

By default, the percentage is coming fine by default is becomes zero when i click on field on field then it shows me the correct percentage and color also changes.

I am using the below expression in background color.

=if((count({<TOT_DUR={'>=07:00'}>} TOT_DUR)/count(TOTAL TOT_DUR)) <= .20, RGB(255,0,0),              /* 0...20% red */

if((count({<TOT_DUR={'>=07:00'}>} TOT_DUR)/ count(TOTAL TOT_DUR))<= .30, RGB(255,255,0),RGB(0,255,0) )) 

It will show red if percentage is below 20%,RED, Yellow, 20-30, GREEN 40-100.

I guess the expression is correct, Why percentage values becomes after refresh and again i have select field to get the correct and color also changes as above.

I have attached the screenshot.

Thanks and Regards

1 Reply
Not applicable

Re: Percentage is showing zero after clicking on clear button

Please somebody assist on this

Community Browser