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

[Lakshmanudui]

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]

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.