topic Re: experssion in QlikView

experssion

srinivasa1 — Fri, 19 Oct 2012 15:10:18 GMT

can any one pls exlpain me

below experssion

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

thanks

Re: experssion

MayilVahanan — Fri, 19 Oct 2012 15:13:50 GMT

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

Re: experssion

Fri, 19 Oct 2012 15:19:39 GMT

This might help you:

http://community.qlik.com/servlet/JiveServlet/previewBody/1867-102-1-1858/QlikLearn-Set-Analysis-Presentation.pdf

Kind regards,

TMF

Re: experssion

Fri, 19 Oct 2012 15:28:19 GMT

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

Regards

-Anil

Re: experssion

srinivasa1 — Sat, 20 Oct 2012 00:58:44 GMT

Hi Thanks for your reply.

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

Re: experssion

Sat, 20 Oct 2012 09:53:00 GMT

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