topic Re: Expression according to fields selected in QlikView

Expression according to fields selected

Mon, 08 Apr 2013 17:42:02 GMT

I have to multiply a value according to the number of months selected:

Months selected: January and February

Amount_bgt: Amount * 2

The problem is that i have this amount compared in a table with another amount (real_amount), since the real_amount has only data in February, the Amount_bgt gest multiplied only by 1.

Anyone can tell me how to fix this?

Thanks!

Re: Expression according to fields selected

MayilVahanan — Mon, 08 Apr 2013 18:20:18 GMT

Use GetselectedCount(Month) and stored it as variable and then use it..

vSelectedCount = GetselectedCount(Month)

Then use like this

Sum(AMOUNT) * vSelectedCount

Hope it helps

Re: Expression according to fields selected

Mon, 08 Apr 2013 18:32:06 GMT

Doesn't work...still appears the value as 1:

Month is Mes, as you can see i have 2 months selected

Re: Expression according to fields selected

MayilVahanan — Tue, 09 Apr 2013 13:35:33 GMT

Can you able to post a sample file.