5 Replies Latest reply: Nov 16, 2017 8:37 AM by Peter Cammaert RSS

    How create table with all possible combination of fields?

    Vitalii Chupryna

      Hi all,

       

      How can I dynamically generate field with all possible combination of fields.

      How can I do this in qlikview

      For example:

      In table below I have three field

       

      CountryCityCurrency
      USANew YorkUSD
      ItalyRomeEuro
      EnglandLondonGBP

       

       

      Combination for one row:

      USA

      New York

      USD

      USA & New York

      New York & USA

      USA & USD

      USD & USA

      New York & USD

      USD & New York

      USA & New York & USD

      New York & USD & USA

      USD & New York & USA

      ...