Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

Could maybe do something like this sample.

View solution in original post

10 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

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
Author

The chart says theres no data to display.

CELAMBARASAN
Partner - Champion
Partner - Champion

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
Author

Could maybe do something like this sample.

Not applicable
Author

It still gives the same error

CELAMBARASAN
Partner - Champion
Partner - Champion

Can u upload sample file

CELAMBARASAN
Partner - Champion
Partner - Champion

If possible upload the file currently ur working

Not applicable
Author

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
Author

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