Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set Analysis with 3 Fields

sum({$<PeriodID ={'3'}>} SalesUnit)

^^ This is in the application I attached earlier in the main text box, center screen. I created this after my initial post so sorry if the naming threw you off.
Open the application and select Blue Customer and Last Month. Based on your equation, I should see "30" units, but I'm getting "0", no? What am I doing wrong?


MVP
MVP

Set Analysis with 3 Fields

Edit: Wait, OK, I see the 0 now, when you DO copy in the expression and do the selections you say, THEN it gets 0. It gets 0 because you are overriding the PeriodID, but making a selection in PeriodDesc. Since these fields are, I gather, the same thing, you ALSO need to tell it to ignore PeriodDesc.

sum({<PeriodID ={'3'},PeriodDesc=>} SalesUnit)

Highlighted
Partner
Partner

Set Analysis with 3 Fields

Try this

sum({$<PeriodID ={'3'}, PeriodDesc = >} SalesUnit)

i.e. you could either set PeriodDesc to be ignored or you could also set it to LastWeek

MVP
MVP

Set Analysis with 3 Fields

The dollar sign is optional. I prefer to not include it since $ is also used in dollar sign expansion and to identify parameters, but I may be in the minority.

Not applicable

Set Analysis with 3 Fields

Thank you everyone - sorry if I confused anyone. Charlotte.qvw's answer fixed the problem