topic Re: One dimension and two measures on a bar chart in App Development

One dimension and two measures on a bar chart

Thu, 11 Dec 2014 10:25:05 GMT

Hi!

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

Thank You

All the best

Przemyslav

Re: One dimension and two measures on a bar chart

thoshino — Thu, 11 Dec 2014 11:40:43 GMT

I think that it can be done with the "CrossTable LOAD" in loadscript.

See the attached QVF.

Re: One dimension and two measures on a bar chart

Anonymous — Fri, 12 Dec 2014 07:46:33 GMT

Yes.

Try creating the script in QlikView first. It has an interface to create cross tables. And then you can copy it to Qlik Sense.

Serhan

Re: One dimension and two measures on a bar chart

Fri, 12 Dec 2014 09:17:55 GMT

Tsutomu,

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.

Serhan,

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

Re: One dimension and two measures on a bar chart

Fri, 12 Dec 2014 12:13:07 GMT

Hi,

There is another way to do it w/out scripting . It's little bit tricky .

Br,