Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Passing Fields Dynamically to straight table-ASAP

Hi,

I have the reuirment like

one list box containing field of a table loaded from some excel file.these fields are dynamically pass to straight table based on selection of item in list box .

suppose list box contains fileds

like in attachemnt if selected country only then it only should visible in straight table if selected both country and employee name then both should be present like this fields shown in table should be equal to number of items selected  and matching to the current seection in list box .

see the attachement

4 Replies
Anonymous
Not applicable
Author

See example in application "Whats New in QlikView11.qvw", it should be in your C:\Program Files\QlikView\Examples\Documents.  Tab "Reports"

IAMDV
Master II
Master II

You can also use named value Pairs. This way you can have a field names in one field!

Not applicable
Author

Hi Mahesh,

Find this link,

http://www.youtube.com/watch?v=j3j49KxkZcw

http://www.youtube.com/watch?v=CTybb8l1a1k

http://community.qlik.com/docs/DOC-4582

Ex,

INPUTFIELD Sales;

LOAD * Inline

[

Year,Month,Sales,Avg

2012,Jan

2012,Feb

2013,Mar

];

Not applicable
Author

you can use getfieldselections for exemple GetFieldSelections(Field)