topic Re: Variables in QlikView

Variables

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

Any idea why this expression doesn't work?

I feel like the syntax is right but it says it is expecting another '}' somewhere

=sum({$(vYTD)}[Total Revenue])

Re: Variables

Anil_Babu_Samineni — Fri, 17 Mar 2017 14:47:38 GMT

May be this?

=sum({< $(vYTD) >}[Total Revenue])

Re: Variables

sunny_talwar — Fri, 17 Mar 2017 14:47:39 GMT

How do you define your variable vYTD?

May be you need this

=Sum({<$(vYTD)>}[Total Revenue])

Re: Variables

khaycock — Fri, 17 Mar 2017 14:48:50 GMT

Nope still has the same error

Re: Variables

khaycock — Fri, 17 Mar 2017 14:48:55 GMT

Nope still has the same error

Re: Variables

Anil_Babu_Samineni — Fri, 17 Mar 2017 14:49:35 GMT

Would you declare the variable

Re: Variables

sunny_talwar — Fri, 17 Mar 2017 14:52:13 GMT

How do you define vYTD?

Re: Variables

avinashelite — Fri, 17 Mar 2017 14:55:16 GMT

what is the condition your trying

=Sum({<Feild_name={'$(vYTD)'}>}[Total Revenue])

you need to define the left hand side

Re: Variables

vishsaggi — Fri, 17 Mar 2017 14:57:55 GMT

Is this right way?

= Sum({< [Total Revenue] = {'$(vYTD)' } >} [Total Revenue])

Re: Variables

avinashelite — Fri, 17 Mar 2017 15:16:12 GMT

Whats the value you have in vYTD and [Total Revenue] ?

Eg. vDate=07/03/2017

and feild = date ... and has value like 07/03/2017, 08/03/2017 ,09/03/2017

= Sum({< [date] = {'$(vDate)' } >} [Total Revenue])

Re: Variables

khaycock — Fri, 17 Mar 2017 15:56:22 GMT

Still has the little red line underneath }

Re: Variables

khaycock — Fri, 17 Mar 2017 15:57:37 GMT

'>=' & vCurrentFiscYearStart & '<=' & Date(Today())

vCurrentFiscYearStart is declared in the master calendar but the date is 1/1/2017

Re: Variables

khaycock — Fri, 17 Mar 2017 15:57:49 GMT

'>=' & vCurrentFiscYearStart & '<=' & Date(Today())

vCurrentFiscYearStart is declared in the master calendar but the date is 1/1/2017

Re: Variables

sunny_talwar — Fri, 17 Mar 2017 16:01:50 GMT

May be this:

=Sum({<DateField = {"$(vYTD)"}>}[Total Revenue])

Re: Variables

khaycock — Fri, 17 Mar 2017 16:07:32 GMT

Okay that didnt come up with an error but because im trying to show previous years YTD i wanted to include that too.. So I added it in like this:

=Sum({<FiscalYear = {$(vPriorFiscalYear)}, CalendarDate = {$(vYTD)}>}[Total Revenue])

And now I'm getting this error:

Re: Variables

Anil_Babu_Samineni — Fri, 17 Mar 2017 16:15:50 GMT

May be use Single colon for Variables. If not use, Double colon

=Sum({<FiscalYear = {'$(vPriorFiscalYear)'}, CalendarDate = {'$(vYTD)'}>} [Total Revenue])

Re: Variables

sunny_talwar — Fri, 17 Mar 2017 16:29:40 GMT

Give this a shot

=Sum({<DateField = {"$(=vYTD)"}>}[Total Revenue])

Re: Variables

sasiparupudi1 — Wed, 22 Mar 2017 07:24:57 GMT

Please look at the following post to see how to pass parameters to qlikview variables

Qlikview Parameterised Variables

Re: Variables

sasiparupudi1 — Wed, 22 Mar 2017 07:37:48 GMT

Declare variables in script:

Let vCurrentFiscYearStart=MakeDate(2017,1,1);

Let vYTD='>=$'&'(=vCurrentFiscYearStart)<=$'&'(=Date(Today(),''DD/MM/YYYY''))';

put

='$(vYTD)' in a text box to see if you get the correct date filter values

Finally

Sum({<CalendarDate = {'$(vYTD)'}>}[Total Revenue])

hth

Sas

Re: Variables

jonnaamb — Wed, 22 Mar 2017 07:38:27 GMT

Hello Kathryn, good day to you

From my experience, I know that variables inside expressions will cause such issues when variables are internally defined within variables. Trying using no variables at all. Put everything into a single expression by not using any variables.

If it works then drill further down by creating a variable this time but make sure it doesn't contain any variables, and go down further. Let me know if it helps.

Best regards,

Ambareesh Jonnavittula