topic Re: Set Analysis with Function and Variable in QlikView

Set Analysis with Function and Variable

Wed, 25 Nov 2020 16:16:04 GMT

Hello Community, I have a doubt about if it is possible create a set analysis working with function and variable at the same time.

I want to do something like this:

sum({<monthname(DateTn)={$(vMonth)}>} Amount)

Thanks for your responses.

Clever_Anjos — Mon, 14 Mar 2016 17:03:39 GMT

You have to use a field on left side, but you can use a variable on right side

Saravanan_Desingh — Mon, 14 Mar 2016 17:07:07 GMT

The above statement wont work.

You have to use Dimensions.

But, we can rewrite as below..

sum({<Dim1={DimValues}>} If(MonthName(DateTn)=$(vMonth), Amount))

Mon, 14 Mar 2016 21:02:54 GMT

I created a column with the monthname of the date, and in the set analysis I compare as the following expression:

sum({<Mes_Txn={$(vMonthA)}>}Amount)

But the issue continues. vMonthA= Feb 2016 (for example)

Thanks

Clever_Anjos — Mon, 14 Mar 2016 21:07:20 GMT

Please check if this works

sum({<Mes_Txn={"$(=vMonthA)"}>}Amount)

Clever_Anjos — Mon, 14 Mar 2016 21:08:08 GMT

Anyway add your expression to a Straight Table with no label for your dimension

Mouse over your column and see how your variable is beeing evaluated

Clever_Anjos — Mon, 14 Mar 2016 21:11:15 GMT

Mon, 14 Mar 2016 21:12:56 GMT

Thanks. That works very good!!!