topic Re: How to do entering input values and then display based on input values data in QlikView

How to do entering input values and then display based on input values data

Lakshmanudui — Thu, 28 Apr 2022 06:16:20 GMT

Hi All,

I have data Like

Code_ID, Country, City, Sales

1001, USA, DC, 100

I want to create one input box to enter the Code_ID.

If I entering any code for example 1001 then, I want to show 1001 data in straight table.

my data having 10k code_id's .

Can you please suggest me how to do entering input data in Qlikview using input box object.

Thanks & Regards,

Lakshman

pooja_prabhu_n — Thu, 28 Apr 2022 07:54:09 GMT

Hi,

Create Input box Properties -> new Variable = vCode_ID

go to Input Box Properties > Constraints > Value List > Select 'Predefined Values in Drop-down'

Select 'Listed Value' > =concat(Code_ID,',')

Users will be able to select code_ID from input box dropdown.

In straight table you can give calculated dimension like if(Code_ID=vCode_ID,1,0) and suppress when value is null.

hope this helps.