topic Re: Bar Graph and Pivot in QlikView

Bar Graph and Pivot

mandilicious — Wed, 25 Nov 2020 16:16:04 GMT

HI All

Please assist I have created bar chart I need to hide what I have highlighted in red in below screen shot:

second Question:

I have pivot table I need Service level to be change to RED if the percentage/value is below/less than SL TARGET and colour green if value is >= SL TARGET please see below:

Looking forward to hear from you all.

Thanks

Re: Bar Graph and Pivot

MK_QSL — Wed, 05 Apr 2017 08:15:11 GMT

Go to your dimension tab. Select appropriate dimension and tick suppress when value is null

Re: Bar Graph and Pivot

mandilicious — Wed, 05 Apr 2017 08:21:23 GMT

Thank you very much for your quick respond its worked wow. First question answered.

Question 2 please.

Re: Bar Graph and Pivot

MK_QSL — Wed, 05 Apr 2017 08:23:31 GMT

Need Data for that..

Otherwise go to expression tab

click on + sign and you will find text color there

Write below expression

If([Service levels] < [SL TARGET], Red(), Green())

Re: Bar Graph and Pivot

mandilicious — Wed, 05 Apr 2017 08:47:03 GMT

Hi Manish

Firstly to calculate SL we used(sum(CallsHandledInTime)/ sum(TotalCallsHandledInCallCentre))

correct me if i am wrong so i used below it it return everything in Red.

If(sum(CallsHandledInTime)/ sum(TotalCallsHandledInCallCentre) < [TargetServiceLevelPercentage], Red(), Green())