topic Re: Pie Chart Help in QlikView

Pie Chart Help

Thu, 12 Jul 2012 20:18:26 GMT

So I have a list of last logon times for my users.

I have certain buckets I need to put them in based on their last logon time in the pie chart.

If their last logon time is <= today() - 120, they need to be in the 'Deletion bucket'

If their last logon time is <= today() -90, they need to be in the 'On Watch' bucket

If their last logon time is anything else, they need to be in the 'Valid' bucket.

I can't seem to think about how to set up the buckets for this in the pie chart

Any ideas?

Re: Pie Chart Help

CELAMBARASAN — Thu, 12 Jul 2012 20:26:52 GMT

Hi,

ValueList('Deletion', 'On Watch', 'Valid') as Dimension

If(ValueList('Deletion', 'On Watch', 'Valid') = 'Deletion',

Count({<LastLogonTime={"<=$(=today() - 120)"}>} Users),

If(ValueList('Deletion', 'On Watch', 'Valid') = 'On Watch',

Count({<LastLogonTime={"<=$(=today() - 90)"}>} Users),

Count({<LastLogonTime={">$(=today() - 90)"}>} Users)) as Expressions

Re: Pie Chart Help

Thu, 12 Jul 2012 20:36:24 GMT

The chart says theres no data to display.

Re: Pie Chart Help

CELAMBARASAN — Thu, 12 Jul 2012 20:37:47 GMT

If(ValueList('Deletion', 'On Watch', 'Valid') = 'Deletion',

Count({<LastLogonTime={"<=$(=today() - 120)"}>} Users),

If(ValueList('Deletion', 'On Watch', 'Valid') = 'On Watch',

Count({<LastLogonTime={"<=$(=today() - 90)"}>} Users),

Count({<LastLogonTime={">$(=today() - 90)"}>} Users)))

missed one closed bracket

Re: Pie Chart Help

Thu, 12 Jul 2012 20:40:11 GMT

Could maybe do something like this sample.

Re: Pie Chart Help

Thu, 12 Jul 2012 20:40:21 GMT

It still gives the same error

Re: Pie Chart Help

CELAMBARASAN — Thu, 12 Jul 2012 20:42:59 GMT

Can u upload sample file

Re: Pie Chart Help

CELAMBARASAN — Thu, 12 Jul 2012 20:44:07 GMT

If possible upload the file currently ur working

Re: Pie Chart Help

Thu, 12 Jul 2012 20:47:38 GMT

This gives me the error 'all values below limit' in the pie chart.

And I'm sorry but I cant upload a file.

Re: Pie Chart Help

Thu, 12 Jul 2012 20:48:54 GMT

It was because I had a different equation in there. Thank you!

Re: Pie Chart Help

Jason_Michaelides — Thu, 12 Jul 2012 22:29:56 GMT

Please mark a correct answer so the thread appears closed.