topic Re: Passing Fields Dynamically to straight table-ASAP in QlikView

Passing Fields Dynamically to straight table-ASAP

Fri, 20 Dec 2013 20:09:05 GMT

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

Re: Passing Fields Dynamically to straight table-ASAP

Anonymous — Fri, 20 Dec 2013 20:14:02 GMT

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

Re: Passing Fields Dynamically to straight table-ASAP

IAMDV — Fri, 20 Dec 2013 23:46:15 GMT

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

Re: Passing Fields Dynamically to straight table-ASAP

Sat, 21 Dec 2013 02:14:21 GMT

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

];

Re: Passing Fields Dynamically to straight table-ASAP

Sat, 21 Dec 2013 09:22:00 GMT

you can use getfieldselections for exemple GetFieldSelections(Field)