topic Re: How to add Alternate States to a variable as a parameter in QlikView

How to add Alternate States to a variable as a parameter

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

Hi,

I have the following variable below. How do I add Alternate States as a parameter to this variable.

vSpend = Sum({<$($1), BRANDLINK={'$2'}>}DISTRIBUTION_AMOUNT)

The Alternate States I have are : Alternate1, Alternate2 and Alternate3

$1 - is used for period - ie YTD, MTD , etc...

$2 - are different brands

Kind regards,

Nayan

Re: How to add Alternate States to a variable as a parameter

sunny_talwar — Wed, 18 Oct 2017 11:33:22 GMT

May be this

vSpend = Sum({[$3]<$($1), BRANDLINK={'$2'}>}DISTRIBUTION_AMOUNT)

Re: How to add Alternate States to a variable as a parameter

Anonymous — Wed, 18 Oct 2017 12:03:28 GMT

Hi Sunny

Thank you for your reply, however it did not work. I get a blank.

Kind regards

Nayan

Re: How to add Alternate States to a variable as a parameter

Anonymous — Wed, 18 Oct 2017 12:20:23 GMT

Hi Sunny

Here is my expression. Is the state in the correct place

$(Alternate1,vSpend(vYTD))

Kind regards

Nayan

Re: How to add Alternate States to a variable as a parameter

Anil_Babu_Samineni — Wed, 18 Oct 2017 12:29:29 GMT

No, Please post full condition

Re: How to add Alternate States to a variable as a parameter

sunny_talwar — Wed, 18 Oct 2017 12:40:40 GMT

What is vYTD now?

Re: How to add Alternate States to a variable as a parameter

Anonymous — Wed, 18 Oct 2017 12:51:33 GMT

Hi Anil

My expression without Alternate States $(vSpendTest(vYTD,FNB)) when expanded is as follows:

Sum({<Year = {'2018'},Period_ID = {"<100"}, BRANDLINK={'FNB'}>} DISTRIBUTION_AMOUNT)

where vYTD : Year = {'$(vMaxYear)'}, Period_ID = {"<=$(vMaxMonth)"}

Hope this helps.

Kind regards

Nayan

Re: How to add Alternate States to a variable as a parameter

sunny_talwar — Wed, 18 Oct 2017 12:53:17 GMT

May be try this

$(vSpendTest(vYTD,FNB, Alternate1))

Re: How to add Alternate States to a variable as a parameter

Anonymous — Wed, 18 Oct 2017 13:00:36 GMT

vYTD will be all transactions up to today. So now will be October 2017. The year, 2018, shown in my reply to Anil , thats the Financial Year.

So what i'm trying to achieve is that I have a Chart Table where I want to create expressions where some are related to Alternate States. I have 3 different list boxes with different Alternate States, and when I select a value from one of the list boxes, it should only affect the expression linking to that list box.

Hope I'm making sense.

Kind regards

Nayan

Re: How to add Alternate States to a variable as a parameter

Anonymous — Wed, 18 Oct 2017 13:15:55 GMT

Hi Sunny

I've tried that, there is a value, but not affected by the selections made in List box relating to Alternate State 1.

kind regards

Nayan

Re: How to add Alternate States to a variable as a parameter

Anonymous — Wed, 18 Oct 2017 13:26:18 GMT

Hi Sunny

I wanted to ask, how does the dollar expansion "$3" links to the Alternate State?

Kind regards

Nayan

Re: How to add Alternate States to a variable as a parameter

sunny_talwar — Wed, 18 Oct 2017 13:26:59 GMT

Dollar sign expansion? Where do you see that?

Re: How to add Alternate States to a variable as a parameter

sunny_talwar — Wed, 18 Oct 2017 13:27:16 GMT

Can you share a sample?

Re: How to add Alternate States to a variable as a parameter

Anonymous — Wed, 18 Oct 2017 13:33:56 GMT

I was referring to $3. Incorrect choice of words.

Re: How to add Alternate States to a variable as a parameter

sunny_talwar — Wed, 18 Oct 2017 13:38:16 GMT

Third parameter in your variable's arguments

$(vSpendTest(vYTD,FNB, Alternate1))

$1 -> vYTD

$2 -> FNB

$3 -> Alternate1

Re: How to add Alternate States to a variable as a parameter

Anonymous — Wed, 18 Oct 2017 13:50:02 GMT

Hi, thanks for clarifying.

Do you perhaps have an example similar to my query?

Kind regards

Nayan

Re: How to add Alternate States to a variable as a parameter

sunny_talwar — Wed, 18 Oct 2017 14:08:41 GMT

I don't

Re: How to add Alternate States to a variable as a parameter

lorenzoconforti — Wed, 18 Oct 2017 21:28:46 GMT

Sum({ $(vAlternateState) <Year = {'2018'},Period_ID = {"<100"}, BRANDLINK={'FNB'}>} DISTRIBUTION_AMOUNT)

vAlternateState definition

=if(XYZ = 'abc', '[Alternate1]','[Alternate2]')

Re: How to add Alternate States to a variable as a parameter

rwunderlich — Wed, 18 Oct 2017 23:41:37 GMT

What version of QlikView?

-Rob

Re: How to add Alternate States to a variable as a parameter

Anonymous — Thu, 19 Oct 2017 09:40:33 GMT

Hi Rob

The version I'm using is 11.2

Kind regards

Nayan