Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I use variable list in set analysis

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.

2 Replies
MVP
MVP

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

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

Not applicable

worked like a charm. Thank you very much