Discussion board where members can get started with Qlik Sense.
As a requirement i have to work on this data for emergency purpose i did make some manual changes in file and completed my task.
But i was wondering how to create cross table in qliksense?
This is Data as given
What i made manually with given data is this:
I'm trying to do it through sense scripting, Any help will be appreciated.
Also is it possible to make stacked bar chart with value on segments of given data points??
May be try with a Transpose():
(html, codepage is 1252, embedded labels, table is @3, filters(
Take a look at this video # 1 and # 2:
Power of Qlik Script - Reshaping Data with Crosstable (video)
Let us know how you do.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Thanks for suggestion. If i create connection of web file and export it its working but if i take from source file which is in excel its giving me error?
Following code is for reference:
(ooxml, embedded labels, table is [Sheet1 (2)],filters(Transpose());