topic Re: How to use variables in expression. in QlikView

How to use variables in expression.

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

Hello,

Here VSelectedMonth = Month

I have a list box of Month field. The requirement is when I select any month in this list box the variable show that month only and using this variable write a expression to see % of sales in that month of 2010 in a Gauge Chart . I wrote this below expression but its not working please help me out.

=sum({$<Year={"2010"},Month={"=$(=VSelectedMonth)"}>}Sales)/sum({<Year={"2010"}>} Sales)

If I write "=sum({$<Year={"2010"},Month={"Jan"}>}Sales)/sum({<Year={"2010"}>} Sales)" it will work only for January month but I want to use that variable.

Thanks in Advance.

Re: How to use variables in expression.

tresB — Tue, 13 Feb 2018 05:55:11 GMT

If you don't include the field in the set analysis, expression would work on - how you select the values from the field. Hence you could try like:

=sum({$<Year={'2010'}>}Sales)/sum({<Year={'2010'}>} Sales)

Or,

=sum({$<Year={'2010'},Month={'$(VSelectedMonth)'}>}Sales)/sum({<Year={'2010'}>} Sales)

Re: How to use variables in expression.

shiveshsingh — Tue, 13 Feb 2018 06:02:54 GMT

Try this

=sum({$<Year={"2010"},Month={"$(=VSelectedMonth)"}>}Sales)/sum({<Year={"2010"}>} Sales)

Re: How to use variables in expression.

debsahoo — Tue, 13 Feb 2018 06:18:21 GMT

I try below code it will show 100% for every month.

=sum({$<Year={'2010'},Month={'$(VSelectedMonth)'}>}Sales)/sum({<Year={'2010'}>} Sales)

Re: How to use variables in expression.

tresB — Tue, 13 Feb 2018 06:21:42 GMT

Include Month bifurcation in the denominator like:

=sum({$<Year={'2010'},Month={'$(VSelectedMonth)'}>}Sales)/sum({<Month,Year={'2010'}>} Sales)

Re: How to use variables in expression.

debsahoo — Tue, 13 Feb 2018 06:27:52 GMT

Thank you Tresesco. It works. But unable to understand the code.

Re: How to use variables in expression.

tresB — Tue, 13 Feb 2018 06:36:16 GMT

Learn more about set analysis: Set Analysis: syntaxes, examples