topic Re: Variable value? in QlikView

Variable value?

khadeer — Tue, 05 Feb 2013 09:09:23 GMT

Hi Everyone,

I have one variable which represents interest, Suppose it giving value for month selections as follows,

Apr- 30, May-40, June-50, July-10

My requirement is when i am selected may it will show total of Apr+May= 70, similarly if i selected june - 30+40+50= 120,

Here i want to add variable value,

I used this expression,

sum({$<Month={"<=$(=Month)"}>}$(Variable)

sum({$<Month={"<=$(=Month)"}>}$(Values)..... For this i am getting correct value. But when i am using same expression for variable, i am getting current selection.

i.e if selecte may, its showing May month value= 40, but i want to show 70

Re: Variable value?

sivarajs — Tue, 05 Feb 2013 09:24:38 GMT

try the below expression

rangesum(Above(total (sum({<Month={">=$(=max(Month)-count(above(Month)))<=$(=Max(Month))"}>} Amount)), 0,RowNo(TOTAL)) )

Re: Variable value?

khadeer — Tue, 05 Feb 2013 09:39:23 GMT

Hi Sivaraj,

Thanx for ur reply, I am gettibg same value as previous.

Re: Variable value?

sivarajs — Tue, 05 Feb 2013 09:59:17 GMT

Chek this file

Re: Variable value?

khadeer — Tue, 05 Feb 2013 10:08:53 GMT

When i am using variable instead of value i am not getting the result.

I dont want to show in a table, I want to show that value in text object.

Re: Variable value?

sivarajs — Tue, 05 Feb 2013 10:18:16 GMT

may i know what $(Values) holds and how you are using? Possible leave a sample

Re: Variable value?

khadeer — Tue, 05 Feb 2013 10:27:43 GMT

=num(sum({$<Cus_ID={66010,66011,66012},Month={$(=min(Month))},BA={'XXX'}>}POB))

+(RangeSum(sum({<Cus_ID={66010,66011,66012},Month={$(=max(Month))},BA={'XXX'}>}Values))

+(num(sum({$<Cus_ID={66010,66011,66012},BA={'XXX'}>}POB))))/2

*0.1475*(VNoOfDaysMonth/365

This is my variable value.

Sorry i am unable to post my sample, I will try if its possible.

Re: Variable value?

khadeer — Tue, 05 Feb 2013 11:18:55 GMT

Any Suggestions?

Re: Variable value?

rlp — Tue, 05 Feb 2013 14:02:30 GMT

Shouldn't the end of expression be

*0.1475*$(VNoOfDaysMonth)/365

instead of

*0.1475*(VNoOfDaysMonth/365

Re: Variable value?

Anonymous — Tue, 05 Feb 2013 19:13:55 GMT

Hi,

Please check the application.

Regards

Re: Variable value?

khadeer — Wed, 06 Feb 2013 10:42:55 GMT

Hi,

Its not working.

My variable is having following expression

=(num(sum({$<Cus_ID={66010,66011,66012},Month={$(=min(Month))},RBUSA={'XXX'},Quarter=>}POB))

(RangeSum(sum({<Cus_ID={66010,66011,66012},Month={$(=max(Month))},RBUSA={'XXX'},Quarter=>}Amount))

(num(sum({$<Cus_ID={66010,66011,66012,},Month={$(=max(Month))},RBUSA={'XXX'},Quarter=>}POB)))))/2

Its giving correct values for every month, quarter n year selection. let my values(variable) are

Apr=100

May=200

June=150

July=300

If i selected Apr,May then 100+200=300 ... this also i am getting for respective selections.

But if i selected may i want to show Apr+May=300 instead of selecting both.

similarly If i selected june 100+200+300

july= 100+200+150+300

Hope i am clear in what i am saying. Its very urgent....

Thanx in advance

Re: Variable value?

sivarajs — Wed, 06 Feb 2013 10:50:30 GMT

can you check how your variable storing all the values for month

I guess on basis of your month selection the variable showing value.It dont holds all the values

Re: Variable value?

khadeer — Wed, 06 Feb 2013 10:55:03 GMT

Its holding the values as per selections,

My varible expression working fine for my requirement.

Re: Variable value?

rlp — Thu, 07 Feb 2013 09:32:38 GMT

I think that the problem is the double Set analysis constraint on month:

- Firstly, the outer constraint is Month={"<=$(=Month)"}

-Secondly, the inner constriants are included into the variable Month={$(=min(Month))}

I tested this situation with fake variables and QlikView badly behaves.

I suggest to invert inner and outer i.e. use Month={$(=min( {$<Month={"<=$(=Month)"}>} Month))}

In order to do it properly, you should parametrize your variable i.e. insert $1 where you want to insert the parameter and call the variable with the syntax $(variable(parameter)

In your case, you should write

Month={$(=min( {$<Month={$1}>} Month))}

and call with

sum($(Variable("<=$(=Month)"))

Regards.

Re: Variable value?

khadeer — Thu, 07 Feb 2013 09:52:52 GMT

Thank you for your reply,

I will try.....