topic Re: Expression in variable not working in QlikView

Expression in variable not working

Anonymous — Thu, 20 Feb 2014 06:20:43 GMT

Hi all

I have a closing stock expression, save that it into variable and use that variable into chart but it showing same value for all the dimension without any selection when i select a particular dimension it is changing..

Expression

=sum({<PostingMonth=,PostingYear=,Period=,PostingDate={"<=$(vInvDate)"}>}Quantity)

In chart i use variable like this

$(vClosingStock)

Here i am attaching a screen shot please provide any suggestion to me

Thanks in advance

Sirajahamed S

Re: Expression in variable not working

sivarajs — Thu, 20 Feb 2014 06:28:06 GMT

try aggr($(vClosingStock),PostingYear) or aggr($(vClosingStock),BudgetCenter)

Re: Expression in variable not working

sundarakumar — Thu, 20 Feb 2014 06:34:01 GMT

Hi Siraj,

Please remove the "=" sign in the variable overview where u have created the variable..

Then it will work fine.

As u have put = in the variable overview, it is calculating without considering dimension in the chart,

it will work fine if u remove it...

Hope it helps.

-Sundar

Re: Expression in variable not working

sujeetsingh — Thu, 20 Feb 2014 06:34:57 GMT

Use aggr()

Re: Expression in variable not working

Anonymous — Thu, 20 Feb 2014 06:40:34 GMT

Hi Sivaraj seeman

thanks for your reply..

that expression also not working it showing the same...

Re: Expression in variable not working

Anonymous — Thu, 20 Feb 2014 06:44:00 GMT

Hi sundarakumar

It is working thanks

when i remove '=' in the expression overview it is working now..

Thanks

Re: Expression in variable not working

Anonymous — Thu, 20 Feb 2014 06:44:13 GMT

Hi,

Thanks lot

Re: Expression in variable not working

MK_QSL — Thu, 20 Feb 2014 06:46:16 GMT

can you post your sample apps?

Re: Expression in variable not working

sundarakumar — Thu, 20 Feb 2014 06:47:17 GMT

Hi Siraj,

Please close the thread, you can do it be marking the correct answer.

Thanks.

-Sundar

Re: Expression in variable not working

er_mohit — Thu, 20 Feb 2014 07:03:08 GMT

Make sure your Posting Date and the variable date have same forat try to use num(PostingDate) in backend and use it

here in variable vInvDate also date in number format

try this way

=sum({<PostingMonth=,PostingYear=,Period=,numPostingDate={'<=$(=vInvDate)'}>}Quantity)

in chart you write ='$(=vClosingStock)'

hope it helps