topic Re: Selectable expression in QlikView

Selectable expression

Thu, 07 Feb 2013 22:12:36 GMT

Hi,

I have a expression where I sum a couple of values on a field.

I want to be able to through the list box only some of the values on the field and the sum should change. Currently this is not working.

Expression :

Sum({<[accnt]={'0000123000','0000456700','000089102000'}>}Poqty

)

Re: Selectable expression

Thu, 07 Feb 2013 22:36:16 GMT

Your syntax is fine for summing up only those three account numbers. What exactly is your desired output? You may need to upload a sample file.

Re: Selectable expression

Sokkorn — Fri, 08 Feb 2013 01:42:23 GMT

Hi,

Your set analysis is working fine with static value from [accnt]. To make it dynamic, you need to get selected field value from other object (mostly ListBox). Now let try set analysis below:

=Sum({$< [accnt] = {$(=Concat(CHR(39) & [ListBoxField] & CHR(39),','))}>} Poqty)

Let me know whether it work or not.

Regards,

Sokkorn

Re: Selectable expression

Fri, 08 Feb 2013 15:40:13 GMT

Hi Sokkorn,

I am not sure how I would be able to place this in my expression. I have to provide certain accnt numbers in the expression and I want to be able to select within those account numbers via a list box. In the above expression where will I provide those account numbers

Re: Selectable expression

Sokkorn — Sun, 10 Feb 2013 10:51:24 GMT

Hi kinjal22,

Let me understand well with you. Is it [accnt] is your field? This field have data like '0000123000','0000456700','000089102000', right? And where you use this expression

=Sum({<[accnt]={'0000123000','0000456700','000089102000'}>} Poqty)? Which sheet object you use this expression? It is possible to share your app?

Regards,

Sokkorn