Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

One dimension and two measures on a bar chart

Hi!

I would like to create a bar chart displaying two variants of one dimension. I have data coded like this (file attached)

wykres4.bmp

And I'm trying to create QS charts, similar to this:

wykres3.bmp

Does anyone have an idea, what scripting should I use?

I will be very thankful for every solution

Thank You

All the best

Przemyslav

4 Replies
thoshino
New Contributor II

Re: One dimension and two measures on a bar chart

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

See the attached QVF.

darkhorse
Valued Contributor

Re: One dimension and two measures on a bar chart

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.

BR

Serhan

Not applicable

Re: One dimension and two measures on a bar chart

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

Not applicable

Re: One dimension and two measures on a bar chart

Hi,

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

Br,

Community Browser