topic Re: Variable is not working Properly in QlikView

Variable is not working Properly

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

HI All,

I have a report where I want to show value on Date Selection. If I select any date, value should be calculating till date.

So I need to use expression like :

=Count({<DT={'<=$(=$(v1))'}>}OrderQuantityOutstanding),

But first I wanted to check whether my variable is working or not. So instead of <= I use only =.

But then also my value is not matching.

I have created two Text Object. With Variable and W/O Variable. Ideally these two should match. But with variable is showing less data.

I am attaching my file.

Could you please check and help me. I am not able to understand where I am making mistake.

Please help.

Thanks,

Sarif

sunny_talwar — Fri, 07 Apr 2017 07:51:19 GMT

One of the text box expression is doing the sum and the other one is doing a count.... You need to either do a sum in both or count

sunny_talwar — Fri, 07 Apr 2017 07:52:53 GMT

Check the attached

mhmmd_srf — Fri, 07 Apr 2017 08:43:53 GMT

Ohhh...my GOD...

I am really sorry Sunny...for wasting your time...

Thanks a lot...