topic Re: Issue with Pie Chart in QlikView

Issue with Pie Chart

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

HI QV Experts,

stalwar1‌- Would you please help on this issue. Appreciate it

I have a pie chart. The strange thing that i notice is that the red portion of the pie does not react when i click on it. The other portions of the pie works just fine except the red portion which has 21%.

I have a calculated dimension which is as follows.

=if(FRCA_Totaldays > 90 , 'Low (>90days)',

if(FRCA_Totaldays > 30 and FRCA_Totaldays <=90 , 'Medium (30 to 90 days)',

if(FRCA_Totaldays <= 30 , 'High (<30days)','Never Loggedin')))

what is not working is the last condition 'Never Loggedin'. Even when i put a condition to calculate never logged in, no luck.

The expression that i have for it is as follows.

=count(FRCA_Activity)/count(total FRCA_Activity)

But there is another pie with similar condition and it works just fine.

Attached is the pie chart.

Thanks for your help

Re: Issue with Pie Chart

manoranjan_d — Thu, 18 Jan 2018 06:51:46 GMT

may be if(FRCA_Totaldays <= 30 , 'High (<30days)','Never Loggedin'))) will have every low value.

some it wont show if you move the cursor the red part will blink

pls share your file

Re: Issue with Pie Chart

pradosh_thakur — Thu, 18 Jan 2018 06:53:09 GMT

what is the condition for never logged in because you have covered <=30,>30 < =90 and >90 , which almost covers everything except if it is null.

please elaborate a bit. it will be hard without the details and what do you mean when you say it is working for another chart ?

Re: Issue with Pie Chart

ramanarayan — Thu, 18 Jan 2018 07:17:47 GMT

Hi PRadosh,

The condition for never logged is this

if(FRCA_Totaldays= blank, 'Never Loggedin'. I tried that also but no luck.

Re: Issue with Pie Chart

pradosh_thakur — Thu, 18 Jan 2018 07:53:08 GMT

Try This

IF(LEN(TRIM(FRCA_Totaldays))=0,'Never Loggedin',if(FRCA_Totaldays > 90 , 'Low (>90days)',

if(FRCA_Totaldays > 30 and FRCA_Totaldays <= 90 , 'Medium (30 to 90 days)',

if(FRCA_Totaldays <= 30 , 'High (<30days)'))))

Re: Issue with Pie Chart

ramanarayan — Thu, 18 Jan 2018 08:05:42 GMT

Hi Pradosh,

No luck unfortunately

Still the red portion does not react upon clicking

Thanks

Re: Issue with Pie Chart

pradosh_thakur — Thu, 18 Jan 2018 08:09:18 GMT

You wont be able to select null. That is the issue it seems.May be some other expert can shed more light into this .

Re: Issue with Pie Chart

sunny_talwar — Mon, 22 Jan 2018 10:44:26 GMT

This might be stupid and I might be make it over simple, but is it possible you have an invisible object on top of your chart where you have the red part in your pie chart? May be try to move the chart to a brand new tab and see if it works.

Re: Issue with Pie Chart

ramanarayan — Mon, 22 Jan 2018 11:29:09 GMT

Thanks Sunny.

I moved the chart to a new sheet but still no luck. ATtached is another chart where i have similar dimension and the red part works just fine. May be you will get some idea if you see this.

Dimension used in the working chart

=If ([Fill Rate-Category]= 'High', 'High >90%',

If ([Fill Rate-Category]= 'Medium', 'Medium 80% to 90%',

If ([Fill Rate-Category]= 'Low', 'Low <80%', 'Never Loggedin')))

Expression used in working chart

=count([Fill Rate-Category])

Thanks to help me on this

Re: Issue with Pie Chart

sunny_talwar — Mon, 22 Jan 2018 11:34:54 GMT

This won't really give me any idea.... your dimension and expression don't seem to say anything either... would you be able to post a trimmed down version of your qvw file?

Preparing examples for Upload - Reduction and Data Scrambling

Re: Issue with Pie Chart

ramanarayan — Mon, 22 Jan 2018 12:05:29 GMT

Hi Sunny,

Attached is the trimmed version of the qvw file. The chart on the left seems to be the trouble maker. The yellow portion (21%) is not working. The chart on the right uses similar calculated dimension and it is working just fine.

Thanks for your help

Re: Issue with Pie Chart

sunny_talwar — Mon, 22 Jan 2018 13:02:07 GMT

I think what you are trying to select it null value in FRCA_Totaldays

May be create a new field in the script like this

If(Len(Trim(FRCA_Totaldays)) = 0, 'Null', FRCA_Totaldays) as NewField

and then try this

=if(NewField> 90 , 'Low (>90days)',

if(NewField> 30 and NewField<=90 , 'Medium (30 to 90 days)',

if(NewField<= 30 , 'High (<30days)','Never Loggedin')))

and see if this works for you

Re: Issue with Pie Chart

ramanarayan — Tue, 23 Jan 2018 10:17:14 GMT

Hi Sunny,

Thanks for your inputs.

I made a minor change in the script formula which you gave.

If(Len(Trim(Totaldays)) = 0, '0', Totaldays) as FRCA_ActualDays

Instead of using 'Null' i made it '0', because the expression formula does not recognize Null as 0.

But still the never logged in bucket goes missing. This is what i see now