topic Re: $ query in QlikView

$ query

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

sum({<Year= {"$ (>=(Max(Month))"}>}Sales)

A bit confused, what if i put = sign before $ sign in string? Please let me know the difference

sum({<Year= {"=$ (>=(Max(Month))"}>}Sales)

Re: $ query

vishsaggi — Sun, 04 Feb 2018 04:31:27 GMT

When ever you use = sign QV takes what ever it reads after = sign as an expression to be evaluated then compared to the field Year. May be not a good way of explaining. But that is what i believe. May be someone can give more insights on this.

Re: $ query

rwunderlich — Sun, 04 Feb 2018 04:34:13 GMT

I don't think either of the examples you posted would be valid syntax. Both would return null. Here are some similar examples with valid sytax.

sum({<Year={2008}>}Sales)

Select the specific value 2008

sum({<Year={">=2008"}>}Sales)

Select >=2008. Use of the >= requires the double quotes.

Now using $() Dollar sign expansion (DSE) to provide a dynamic value. DSE is executed first to create a substitution, then then the expression is evaluated.

sum({<Year={$(vYear)}>}Sales)

Select the value of variable vYear.

sum({<Year={$(=Max(Year))}>}Sales)

Select the Max possible Year. Requires DSE. The = after the left paren indicates this should be evaluated as an expression.

sum({<Year={">=$(=Max(Year))"}>}Sales)

Same as above but testing for >=. Note that >= requires the double quotes. The >= goes before the DSE.

Some further reading.

The Magic of Dollar Expansions

Quotes in Set Analysis

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: $ query

shiveshsingh — Mon, 05 Feb 2018 06:06:12 GMT

Thanks Rob,

There was syntax error in expression.

Please help me in understanding significance of '=' sign before $

Sum({<Year={"=$(=Max(Year)-1)"},Month={'<=$(vMaxMonth)'}>}Sales)

Sum({<Year={"$(=Max(Year)-1)"},Month={'<=$(vMaxMonth)'}>}Sales)

Re: $ query

rwunderlich — Tue, 06 Feb 2018 02:04:20 GMT

Sum({<Year={"=$(=Max(Year)-1)"},Month={'<=$(vMaxMonth)'}>}Sales)

As far as I know it is not valid to place a "=" before the "$" in this context. Does this expression return results for you?

-Rob

Re: $ query

shiveshsingh — Tue, 06 Feb 2018 05:27:57 GMT

Hi Rob,

I am getting results if i put '=' sign before $. But it is different from without '=' sign.

I was checking this just out of curiosity.

Re: $ query

pradosh_thakur — Tue, 06 Feb 2018 07:27:45 GMT

Is the result of

Sum({<Year={"=$(=Max(Year)-1)"},Month={'<=$(vMaxMonth)'}>}Sales) same as

Sum({<Month={'<=$(vMaxMonth)'}>}Sales) or

sum(Sales) ?

Re: $ query

shiveshsingh — Tue, 06 Feb 2018 16:19:49 GMT