topic Re: Set Analysis instead of IF in QlikView

Set Analysis instead of IF

MK_QSL — Mon, 17 Jun 2013 15:08:43 GMT

I have variable vInvoiceTotal giving total of invoice value.

Data are having three years 2011, 2012 and 2013.

I want to show below using SET ANALYSIS.

If (Year = ‘2011’, $(vInvoiceTotal))

I have enclosed exaple showing yearwise invoice total using IF.. Need Set Analysis to give the same result in straight table.

Mon, 17 Jun 2013 15:30:04 GMT

Not sure what your variable looks like, so the content of the variable might change this, but it would be something like:

Sum({$<[Year]={"=2011"}> YourValue )

prodanov — Mon, 17 Jun 2013 15:31:31 GMT

Attach an application!

See data format on field Year, if it is a number you must delete '. If this don't help change formula to $(=vInvoiceTotal)

MK_QSL — Mon, 17 Jun 2013 15:55:29 GMT

I have attached file...

prodanov — Mon, 17 Jun 2013 16:01:03 GMT

Change expression to $(vTotal)

MK_QSL — Mon, 17 Jun 2013 16:05:11 GMT

This is true for Pivot table but how can i get the same result from Straight Table.... There should be four columns.

Invoice No, Year 2011, Year 2012, Year 2013.

prodanov — Mon, 17 Jun 2013 16:11:44 GMT

Must be same in straight table. Even in any other object

MK_QSL — Mon, 17 Jun 2013 16:13:59 GMT

My question is how to get the same result in straight table using set analysis & variable.

need three different columns for expressions.... i.e. Year 2011, Year 2012, Year 2013...

prodanov — Mon, 17 Jun 2013 17:04:03 GMT

See this application

MK_QSL — Mon, 17 Jun 2013 19:04:24 GMT

Excellent.... This is what I was looking for.... Thanks for your help