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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic Readout

Hi all,

I have searched the forum but couldn't find an answer to my question maybe you can help me out:

I have loaded a database table and one of the fields i'm loading contains values like Books, EMail, Newspapers:

MyValue:

Books,

EMail,

Newspapers

Now i want to count the sales for each of the different Books, EMail, Newspapers but i don't want to use an if statement in my chart like:

If(MyValue='Books', count(sales))

I need it dynamically! In case i will have assigned a new MyValue like Magazines the sales should be automatically counted for this new value and shown.

Hope my question is clear. In case you have any questions please let me know.

Best

Harry

1 Reply
alexandros17
Partner - Champion III
Partner - Champion III

You can use MyValue as dimension and your expression will simple be Sum(Sales), this value vill be automatically splitted into all the values of your MyValue field.

Let me know