Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to load a Excel spreadsheet that is pivoted and I can't find a wizard that would make that easy.
Hi Olivier,
QlikSense does have a transformation wizard but its not as robust as QlikView yet. You always use the transformation wizard in QV and paste the code in QlikSense. That will cause no harm at all.
should I use QV desktop to create the script then paste it in Qlik Sense?
Hi Olivier,
QlikSense does have a transformation wizard but its not as robust as QlikView yet. You always use the transformation wizard in QV and paste the code in QlikSense. That will cause no harm at all.
Hi
Use crosstable statement in your script.
https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable
See that link
Bruno
Thanks guys for your quick follow-up. I ended up using the wizard in QV desktop to generate the script (including the crosstable statement) and pasting it in QS worked fine. Let's hope they improve the wizard in QS soon