Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.