Set Analysis in Qlikview

set_analysis
qlikview

#1

Hi,

I have learnt QlikView by reading books and watching some TouTube channels. Now, I’m developing a sales dashboard, where I have to create a table to show sales comparison over years. Assume current year selection is 2013 then comparison with 2012 and if current selection is 2014 and month is May then comparison should be with 2013 and May. I have stored last year and last month value in two variables vlastyear and vlastmonth. I have also used set analysis to compare it using following syntax:

=Sum( {$<Year = {$(vlastyear)}, Month = {=<$(vlastmonth)"}> sales)

but above syntax is not working, please help me to correct this.

Thanks,
Satish


#2

@Satish

Below is corrected syntax:

=Sum( {$<Year = {$(vLastyear)} , Month = {$(vlastmonth)}>} Sales)

For more detail on Set Analysis, you can refer below link:

Regards,
Sunil