2 Replies Latest reply: Jul 9, 2017 6:57 AM by shay bitton RSS

    Qlik Sense - Change Excel Output

    shay bitton

      Hi,

       

      I'm facing a Difference between QV & QS.

       

      In QV, no matter if I use a regular table or a pivot table, when I export these, the excel file looks the same - a full data set - Merged

      In QS the excel file look as as it seen in the original table - Un-Merged



      the problem is that i need to merge the values in all dimensions one by one- and it takes a long time when you have a large data set.


      i have to use the pivot since i need the dynamic label in the expressions.

       

      Image attached.

       

      EXP.png.

       

       

       

       

      Any ideas?

      Thanks in advanced