topic Re: store variable values in QlikView

store variable values

vikasmahajan — Tue, 24 Nov 2015 11:21:59 GMT

Hi all ,

I have field like [NonPrdBkp.Monthly Charges] which i stored into variable vInititiavtiveCharges

Now I want to use this variable for following set analysis

vInitiviativeChargesTotal = num(Sum({<[$(vInititiavtiveUpdateStatus)] = {'Review'}>} [$(vInititiavtiveCharges)]),'$#,##0')

I am getting error for this ..

Any body please give suggessions.

Vikas

Re: store variable values

sunny_talwar — Tue, 24 Nov 2015 11:24:42 GMT

So you have this -> vInititiavtiveCharges = [NonPrdBkp.Monthly Charges] ?

May be try it without the square brackets

vInitiviativeChargesTotal = num(Sum({<[$(vInititiavtiveUpdateStatus)] = {'Review'}>} $(vInititiavtiveCharges)),'$#,##0')

Re: store variable values

Anonymous — Tue, 24 Nov 2015 11:26:20 GMT

why you required vInititiavtiveCharges and vInititiavtiveUpdateStatus?

Simply try with your field name only..

Total = num(Sum({<FieldName= {'Review'}>} FieldName1),'$#,##0')

Re: store variable values

jonathandienst — Tue, 24 Nov 2015 11:32:58 GMT

Its kinda hard to debug your variables and expression without knowing how the variables are defined...

Re: store variable values

vikasmahajan — Tue, 24 Nov 2015 11:37:29 GMT

i am getting error for this set [$(vInititiavtiveUpdateStatus)] = {'Review'}

Re: store variable values

sunny_talwar — Tue, 24 Nov 2015 11:39:25 GMT

Again I don't think you should use square brackets around your variable. Try without it.

Note: Expression Editor may still show your red line underneath, but the expression might still work because your variable contains a single field name. I have never tried it, but I have a feeling it should work.

Re: store variable values

vikasmahajan — Tue, 24 Nov 2015 11:41:40 GMT

after removing square brackets also it is not working ?

Re: store variable values

sunny_talwar — Tue, 24 Nov 2015 11:49:29 GMT

This sample seems to work.

Script:

Table:

LOAD * Inline [

ABC

];

Text Box Expression - > =Sum({<$(vVar) = {1, 2, 3}>}$(vVar))

Re: store variable values

gsbeaton — Tue, 24 Nov 2015 12:13:52 GMT

Hi Vikas,

What you are doing should, in principle, work, but you need to check your variable is parsing out to a field name, rather than the contents of the field.

You should double check what your variable $(vInititiavtiveUpdateStatus) actually contains. Try putting the variable into a text box. Does it parse out to exactly your field name [NonPrdBkp.Monthly Charges]? What I suspect you will get in your text box is a - (dash). Try then putting =concat($(vInititiavtiveUpdateStatus),',' ) into the text box. Do you see the entire contents of field? If so, then you need to go back to your logic and make sure you are storing the field name in your variable, rather than the contents of your field.

I hope that helps.

George

Re: store variable values

vikasmahajan — Tue, 24 Nov 2015 12:53:42 GMT

Thanks all for Reply...

Vikas