Discussion board where members can learn more about Qlik Sense App Development and Usage.
I would like to create a bar chart displaying two variants of one dimension. I have data coded like this (file attached)
And I'm trying to create QS charts, similar to this:
Does anyone have an idea, what scripting should I use?
I will be very thankful for every solution
All the best
I think that it can be done with the "CrossTable LOAD" in loadscript.
See the attached QVF.
Try creating the script in QlikView first. It has an interface to create cross tables. And then you can copy it to Qlik Sense.
Thank you very much for your answer. Actually, it works well but synthetic keys appear and I wonder if it's ok. I'm gona try to find out a solution to avoid it.
I'm gonna get into QlikView - its a good idea, thanks for advise.
I'll be back here in 2 days and tell you what I find out.
Thanks for discussion
There is another way to do it w/out scripting . It's little bit tricky .