topic input box in QlikView

input box

Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 13 Feb 2017 07:39:48 GMT

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

prat1507 — Mon, 13 Feb 2017 07:47:48 GMT

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

Regards

Pratyush