Solved: input box - Qlik Community

Report Inappropriate Content · ‎2017-02-13

A table contains products and sales

My script looks like in text object,

Sum({<product={'$(Vproduct)'}>}sales)

It works fine if I enter single product in inputbox.

But now the requirement is

If I enter multiple products in input box then it should display total sales of the respective products.

How to achieve this??

Please suggest!!!

Thanks in advance!

kaushiknsolanki · ‎2017-02-13

HI,

You can try this.

Sum({<Product = p(Product) >}Sales)

This way you can get the sales of all product without selection and when you make selection it will give for those products.

For multiple values in variable you can try below.

Make sure that values are separated by Comma in variable.

Sum({<Product= {"$(=Replace(vTest,',','","'))"}>}Sales)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

kaushiknsolanki · ‎2017-02-13

HI,

You can try this.

Sum({<Product = p(Product) >}Sales)

This way you can get the sales of all product without selection and when you make selection it will give for those products.

For multiple values in variable you can try below.

Make sure that values are separated by Comma in variable.

Sum({<Product= {"$(=Replace(vTest,',','","'))"}>}Sales)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

prat1507 · ‎2017-02-13

Hi

Please use =Sum({<Fmonth={'$(=replace(Vproduct,',',chr(39)&','&chr(39)))'}>}sales) when you're entering multiple items( i hope separated by commas).

Regards

Pratyush

input box