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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selection in set analysis

I have a set analys that works very good but I would have a new chart on the same sheet that show another

product without choosing it from  a field box. I have the set in an variable and have tried to extend it but it doesn´t work.

PeriodID = {$(=Max(PeriodID))},{<MaterialNr={D102328}>},
Year = ,
Quarter= ,
Month= ,
Period=

this expands the variable:

Sum({$<$(DNEYE)>} [DebPris]/100)

And this is what I like to achieve:

Chart.png

I have tried a lot of different things to get the value only for this MaterialNr

kindly

Håkan

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

PeriodID = {$(=Max(PeriodID))},

MaterialNr={'D102328'},

Year = ,

Quarter= ,

Month= ,

Period=

View solution in original post

2 Replies
MK_QSL
MVP
MVP

PeriodID = {$(=Max(PeriodID))},

MaterialNr={'D102328'},

Year = ,

Quarter= ,

Month= ,

Period=

Not applicable
Author

Thanks for a very fas response.

Håkan