Qlik Sense - Change Excel Output

[shaybitton]

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.

.

Any ideas?

Thanks in advanced

[passionate]

If you are using Qlikview 12.X then

1. you can binary load this Qliksense file into qlikview

2. create your pivot in Qlikview.

3. Export this pivot table your issue will be resolved.

Regards,

Pankaj

[shaybitton]

Hi Pankaj,

I'm Using Qlik Sense and i need it to be on a regular basis for the users.

Thanks,

Shay