Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expressions dynamically

Hi All,

I have 4 expression as below, these are based on Status field.

My Question is I would like to keep this dynamically. Because Status field may contains different values instead of (Completed/Medium/High/Low). Based on the status field I have Sum it up and show as below.

In Status field I might have (Error, Solved, In-progress, Deleted). I need the expression dynamically based on Status field values.

Second is- Is it possible without above expressions to sum up and show chart total by groups?

Can anyone help on this please.

Thanks,

Lakshmi.

1 Reply
JonnyPoole
Former Employee
Former Employee

Add 'Status' as a 2nd dimension , then your expression would count the records. Something like count(Status).

That would be completely dynamic.