How to filter the data

[amithmurali]

Hi guys,

Suppose in my table,

i want to show comparison of this year data with the previous year data. when i compare it in  a gauge. its taking the data for the entire previous year and comparing with the 4months of the current year.

i have data for the entire year 2014 and till may for 2015. when i compare it should make a division like "2015 data till may / 2014 data till may".

[avinashelite]

check this threads:

QlikView App: Set Analysis - Prior Period Comparison

Year-over-Year Comparisons

Comparing Current Month and Previous Month Sales

[MayilVahanan]

Hi

Try like this

vMaxMonth  <-- its store the May month value (i.e. Max month value of the current year)

Sum({<Year = {$(=max(Year))}, Month = {"<=$(vMaxMonth)"}>}Sales) /

Sum({<Year = {$(=max(Year)-1)}, Month = {"<=$(vMaxMonth)"}>}Sales)

[amithmurali]

Can you explain in detail. i am new to qlikview.

[sujeetsingh]

Just try to study all about Set Analysis

[amithmurali · Accepted solution]

vMaxYear:   =Year(Max(Date))

vPriorYear     =(year(Max(Date))-1)

vMaxMonth     =max({<Year={'$(vMaxYear)'}>}Month)

vMinMonth     =min({<Year={'$(vMaxYear)'}>}Month)

The set analysis that i made is

sum({<Year={'$(vMaxYear)'},Month={'>=$(vMinMonth)<=$(vMaxMonth)'}>}Value)/

sum({<Year={'$(vPriorYear)'},Month={'>=$(vMinMonth)<=$(vMaxMonth)'}>}Value)