4 Replies Latest reply: Jan 27, 2015 8:00 AM by Joseph Simmons RSS

    Field Names in variable

    Qlik View

      Hi friends

       

      i need all the filtered list box values in textbox.

       

      eg: I have an expression like.

       

      if(assets='ABC',

      Count ({$<[assets] = {'Assest1','Assest2','Assest3','Assest4'}, 

      [group] = {'$(Valcoholoc1)'} >} DISTINCT TOTAL [Value] ))

       

       

      here = Assest1, Assest2, Assests3 are the field names which are hard coded. in place of hardcode i want to replace it with variable...

      assets is a column name in listbox. for example employee is a listbox, if i select A in another field the employee names will get filter in employee listbox(Table). So filtered field names should be placed in variable so that i can replace in the above expression,

       

      I can use like =GetFieldSelections([assets],', ',2

       

      But this wrks when we select multiple fields. i need the field names which are just filtered in listbox.