topic How can I use variable list in set analysis in QlikView

How can I use variable list in set analysis

Mon, 24 Aug 2015 14:09:25 GMT

Hi all,

I have an issue in getting my formula to Work when using multible values in a variable.

Image 1 is an inputbox with ordernumbers

and my set analysis formula is

=num(sum({1< OrderNumber = {"$(=V_Excluded)"} >} OpenordersAmountDKK) ,'#.##0')

If I only have one value, the formula Works just fine, but I would like it to Work with the possibility of more entries.

Any good ideas out there?

Thx in advance.

swuehl — Mon, 24 Aug 2015 19:33:38 GMT

Try to use commas instead of semicolons as separator in the input box, then

=num(sum({1< OrderNumber = {$(=V_Excluded)} >} OpenordersAmountDKK) ,'#.##0')

Tue, 25 Aug 2015 06:30:47 GMT

worked like a charm. Thank you very much