Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

Qlik Sense - Change Excel Output

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

2 Replies
Specialist
Specialist

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

Partner
Partner

Hi Pankaj,

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

Thanks,

Shay