topic Re: var not working in QlikView

var not working

soniasweety — Sat, 16 Nov 2024 20:57:42 GMT

Hi all,

@sunny_talwar

i am using this in script. but one variable is not working its showing when i add in text object expression garbage

Re: var not working

sunny_talwar — Tue, 30 Apr 2019 14:58:26 GMT

Would you be able to show an image of these three variable in variable overview

Re: var not working

soniasweety — Tue, 07 May 2019 11:15:45 GMT

Hi sunny,

second variable we are not using anywhere so no issue with that.

remaining two screen shots. in dashboard quarter is selected 2019Q2 on open.(Max quarter)

Re: var not working

soniasweety — Tue, 07 May 2019 11:16:10 GMT

i n text object added variable the below error is coming.

Re: var not working

sunny_talwar — Tue, 30 Apr 2019 15:12:26 GMT

Just try to use =vPrevYrQtr in the text box object instead of =$(vPrevYrQtr)

Re: var not working

soniasweety — Tue, 07 May 2019 11:16:39 GMT

the result is 111180.45 but when use that variable in expression its giving me 0

Re: var not working

sunny_talwar — Tue, 30 Apr 2019 15:19:32 GMT

Change the expression to this

=sum({$<Year,Half_Year,Quarter={$(=vPrevYrQtr)},Type={'SR'}>}SA)
+sum({$<Year,Half_Year,Quarter={$(=vPrevYrQtr)},Type={'SR'}>}SA)

Re: var not working

soniasweety — Tue, 07 May 2019 11:17:50 GMT

getting error

Re: var not working

sunny_talwar — Tue, 30 Apr 2019 15:31:05 GMT

Add single quotes or double quotes

=sum({$<Year,Half_Year,Quarter={'$(=vPrevYrQtr)'},Type={'SR'}>}SA)
+sum({$<Year,Half_Year,Quarter={'$(=vPrevYrQtr)'},Type={'SR'}>}SA)

=sum({$<Year,Half_Year,Quarter={"$(=vPrevYrQtr)"},Type={'SR'}>}SA)
+sum({$<Year,Half_Year,Quarter={"$(=vPrevYrQtr)"},Type={'SR'}>}SA)

Re: var not working

soniasweety — Tue, 30 Apr 2019 15:39:25 GMT

thank you sunny first one is working.. but.. when i select 2018Q4 or some other year quarter ... the variable value in the listbox is not changing means it should show 2017Q4 but still its showing 2018Q2 ( this is the default year selected is 2019Q2 so prev yr qtr is 2018Q2 )

Re: var not working

sunny_talwar — Tue, 30 Apr 2019 15:40:47 GMT

Then why are you doing this in the script? use the expression on the variable overview 🙂

Re: var not working

soniasweety — Tue, 30 Apr 2019 15:48:06 GMT

tried the same no luck

Re: var not working

sunny_talwar — Tue, 30 Apr 2019 15:49:21 GMT

please share a sample