Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Pie Chart Help

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?

1 Solution

Accepted Solutions
Not applicable

Re: Pie Chart Help

Could maybe do something like this sample.

10 Replies

Re: Pie Chart Help

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

Not applicable

Re: Pie Chart Help

The chart says theres no data to display.

Re: Pie Chart Help

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

Not applicable

Re: Pie Chart Help

Could maybe do something like this sample.

Not applicable

Re: Pie Chart Help

It still gives the same error

Re: Pie Chart Help

Can u upload sample file

Re: Pie Chart Help

If possible upload the file currently ur working

Not applicable

Re: Pie Chart Help

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

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

Not applicable

Re: Pie Chart Help

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

Community Browser