topic Re: How to filter the data in QlikView

How to filter the data

amithmurali — Tue, 23 Jun 2015 10:03:55 GMT

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".

Re: How to filter the data

avinashelite — Tue, 23 Jun 2015 10:09:07 GMT

check this threads:

QlikView App: Set Analysis - Prior Period Comparison

Year-over-Year Comparisons

Comparing Current Month and Previous Month Sales

Re: How to filter the data

MayilVahanan — Tue, 23 Jun 2015 10:11:37 GMT

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)

Re: How to filter the data

amithmurali — Wed, 24 Jun 2015 04:20:12 GMT

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

Re: How to filter the data

sujeetsingh — Wed, 24 Jun 2015 04:38:56 GMT

Just try to study all about Set Analysis

Re: How to filter the data

amithmurali — Wed, 24 Jun 2015 04:41:38 GMT

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)