5 Replies Latest reply: Oct 20, 2012 5:53 AM by Anil Kumar

Hi

can any one pls exlpain me

Sum({\$<Year={\$(=Max(Year)),
\$(=Max(Year)-1)}>}  Sales / \$(vCurrency))

thanks

Hi

Its sum the sales for maximum year ans maximum year -1 and divide by currency variable value

for example.

Year

2009

2010

2011

2012

its sum the  2012 and 2011 year sales  and divide by variablevalue

Hi

Kind regards,

TMF

hi, Set Analysis used in this expression. Explore about Set Analysis in community. There is a lot of information in community.

Regards

-Anil

my data as below

Medical 30-Sep-12 50
Medical 30-Sep-12 50
sum=100

Dental 31-Sep-2012 100
Dental 31-Sep-2012 100

sum=200

Now i need to calcaulte 200-100=100 how i can achive this in qlikview by useing set analysis

thanks

Hi Srinivasa1,

First you have to understand basics of QlikView, like data management, basics of Set Analysis and how QlikView work.

QlikView load data distinctly, when the data source have two identical row then QlikView load single row only due its default behavior, rather than both row, if you need both row then you have use no distinct or other mechanism in load.

When you filtered data with the selection of a dimension and you want to calculate something beyond this selected dimension value then you need Set Analysis.

For example there is dimension in your data set say Year, and you chose Year : 2009 and you want to calculate sales value of year 2008 or 2009 then you need to use of Set Analysis.

In your case, suppose you selected Dental then you have to wright.

Sum(Value) – sum( { \$ < Nature={‘Medical’} > } Value)

Hope it will help.

Regards

Anil