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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help on Set Analysis syntax on bringing in all values

First let me say I'm extremely new to Qlikview (a week). Great tool!! Anyway,
I'm trying to create a chart that shows me Products (Dimension) by the following Expressions, Sales, ProductTheme, Sales Channel, MonthandYear and finally %Change (% changes in MonthandYear).

However, I'm guessing because I can have several Products in the Channels and MonthandYear, I get very little data (mostly dashes). I'm guessing because I do get some dates, assuming only one Product was sold in that MonthandYear.

And, after all that, I'm really struggling with the syntax for the %Change. Here are a few of the things I've tried;

//Sum ({$<Calendarwrittenmonthandyear>]} SalesAmount)/CalendarWrittenMonthAndYear-1]}SalesAmount)-1]}

//(sum({$<CalendarWrittenYear={$(=max(CalendarWrittenYear))}>} SalesAmount)-sum({$<CalendarWrittenYear={$(=max(CalendarWrittenYear)-1)}>} SalesAmount))/sum({$<CalendarWrittenYear={$(=max(CalendarWrittenYear)-1)}>} SalesAmount)

//sum({$<CalendarWrittenmonthandYear-1>={$(max(CalendarWrittenMonthandYear))}>} SalesAmount) /sum({$<CalendarWrittenMonthandYear={$(=max(CalendarWrittenMonthandYear>}SalesAmount)-1

//(sum({$<CalendarWrittenMonthandYear={$(=CalendarWrittenMonthandYear)-1>SalesAmount)/sum({$<CalendarWrittenMonthandYear>} SalesAmount)-1

//sum({$<CalendarWrittenMonthandYear={(CalendarWrittenMonthandYear-1/CalendarWrittenMonthandYear>)-1> SalesAmount)

sum({[Variable2]}SalesAmount)

Where Variable2 = (CalendarWrittenMonthAndYear-1/CalendarWrittenMonthAndYear)-1

Can anyone Please Help!!

And my apologies in advance if I'm wasting anyone's time for such a simple question.

Thanks

1 Reply
sebastiandperei
Specialist
Specialist

You should send a sample