topic Set Analysis using <= in QlikView

Set Analysis using <=

tmumaw — Fri, 17 Sep 2010 16:38:31 GMT

Hello All,

I am having an issue using the following stmt: sum({<FISYR <= {$(vFisYr)}, RTDFlag = {1}>} [R&M]). It's just not working. Help.

Thanks

I know it's a syntax issue, but just cant find it.

Set Analysis using <=

Fri, 17 Sep 2010 17:03:10 GMT

Hi there,

The correct syntax would be:

sum({<FISYR = {"<=$(vFisYr)"}, RTDFlag = {1}>} [R&M]).

Regards

Set Analysis using <=

tmumaw — Fri, 17 Sep 2010 17:41:41 GMT

thanks....perfect. this one seems to work, but just want to be sure on the syntax.

sum({<FISYR = {$(vFisYr)}, [Installed in Cost Ct_ZINSTALLED] = {X}, MTDFlag = {1}>} [R&M])

Set Analysis using <=

tmumaw — Tue, 21 Sep 2010 14:22:00 GMT

Need some help with Set Analysis. I don't want the user to have to enter a fiscal year, so here is what I put together, however it does not work the way I thought it should.

sum({<FISYR = {$(vFisYr)}, MTDFlag = {1}>} [Total Costs])

My $(vFisYr) should be equal to 2010, however it returns everything and makes the user enter the FISYR. Thanks

Set Analysis using <=

Tue, 21 Sep 2010 15:42:07 GMT

Hi Thom, I dont know if understood correctly, but if you want the set analysis working even if the user hasn't selected a Fiscal Year, then you can use the max function to select the always the maximum year available, like this:

sum({<FISYR = {$(=max(FISYR))}, MTDFlag = {1}>} [Total Costs])

Regards

Set Analysis using <=

tmumaw — Wed, 22 Sep 2010 18:25:14 GMT

Ivan,

Thanks....That is exactly what I was looking for. I was in Chicago at Q-Days and took the set analysis class, but it was like a "Firehose" class. Everything was thrown at you so fast it will take some time to sink-in.

Thom