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: 
geogou1973
Creator
Creator

set analysis expression

Hello.

I have some data like

date - store - item - value - discount

Also i have a variable that is the date-1

how can i bring in a chart with set analysis the items that the date is date-1 with the value and the discount > 20 %

Please help

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Use item as dimension and as expression =sum({<date={$(vMyVariable)},discount={>0.2}>}1). If that doesn't work, please post a document with example data.


talk is cheap, supply exceeds demand