topic Re: set analysis and if in QlikView

set analysis and if

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

if have variable which contains if and set analysis and i dont want to change it.

but if i want to add if before the variable - the answer is not correct.

for example - Sales=

$(vMeasure) =if(VAT='NO VAT', sum( {< YEAR = {$(vCurrYear)} >} [TOTAL SALE)],sum( {< YEAR = {$(vCurrYear)} >}[TOTAL SALE AND VAT]))

now i want to show sales for branch 121 all the time (but still without changing $(vMeasure)

Sum({<branch={121}>} aggr ($(vMeasure_CY),[month and year])) - But it doesnt work

How can i do it??

help

Re: set analysis and if

Anonymous — Thu, 14 Apr 2016 08:59:10 GMT

Hi,

Please try Sum({<branch={'121'}>} aggr ($(vMeasure_CY),[month and year]))

and $(vMeasure) =if(VAT='NO VAT', sum( {< YEAR = {$(vCurrYear)} >} [TOTAL SALE]),sum( {< YEAR = {$(vCurrYear)} >}[TOTAL SALE AND VAT]))

Re: set analysis and if

Anonymous — Thu, 14 Apr 2016 09:03:41 GMT

Hi ,

thank for you answer - but i dont understand your answer ..

which line should i try ?

the $(vMeasure) should stay without any change

Re: set analysis and if

Gysbert_Wassenaar — Thu, 14 Apr 2016 09:06:02 GMT

Can you post a small qlikview document that demonstrates the problem?

Re: set analysis and if

Anonymous — Thu, 14 Apr 2016 09:13:40 GMT

its a bit problem because im using excel and havr lot of sources

Re: set analysis and if

sunny_talwar — Thu, 14 Apr 2016 09:31:53 GMT

I agree with Gysbert, would you be able to share a sample to look at the issue?

Re: set analysis and if

avinashelite — Thu, 14 Apr 2016 09:34:41 GMT

Did not understand your problem , could you please elaborate bit more with sample output required

Re: set analysis and if

Anonymous — Thu, 14 Apr 2016 10:05:33 GMT

Hi again ,

i'll try to be more clear about it -

i have a variable in my model - $(vMeasure_CY)

this variable show the sales for the current year..

i'm trying to write this set (i dont want to change $(vMeasure_CY) 😞

Sum({<branch={'121'}>} aggr ($(vMeasure_CY),[month and year]))

but without any success...

Re: set analysis and if

Anonymous — Thu, 14 Apr 2016 10:06:49 GMT

i actually want the sales of the current year for branch 121 using $(vMeasure_CY) )

Re: set analysis and if

Anonymous — Thu, 14 Apr 2016 10:50:27 GMT

Hi,

I saw some syntax errors so I thought maybe that is why your script was not working

Re: set analysis and if

Anonymous — Thu, 14 Apr 2016 10:52:20 GMT

i wish it was the problem

Re: set analysis and if

avinashelite — Thu, 14 Apr 2016 11:41:34 GMT

please share the sample data