Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

GiuQlik7
New Contributor II

Issue with distribution plot

Hello,

since few days ago, I'm using Qlik Sense to learn how to use the tool. I'm doing small projects, one of them is the use of distribution plots.

Unfortunately I'm having different difficulties in getting what I would like.

For example, from this table:

 WEEK
MovementDay 1Day 2Day 3Day 4Day 5Day 6Day 7Day 8
IN5231.0932.0335971.5801.3421.9491.009
OUT811.173(1.005)(62.992)(121)(239)6363

 

I want this kind of result:

plot.jpg

For this chart I know that only one measure can be selected, in my case (Day1).  How can I get distribution for all single days? Do I have to change any settings before uploading data?

 

 

 

 

 

 

 

 

 

Thanks for your help.

1 Solution

Accepted Solutions
Highlighted
christophebrault
Valued Contributor

Re: Issue with distribution plot

hi,

To get your chart as desired, you should have days as a dimension.

Your Table will look like :

Movement, NoOfDay,IN,OUT

You cloud use Crosstable() in the load script to transform your data

 

Keep learning !

Cheers

 

3 Replies
Highlighted
christophebrault
Valued Contributor

Re: Issue with distribution plot

hi,

To get your chart as desired, you should have days as a dimension.

Your Table will look like :

Movement, NoOfDay,IN,OUT

You cloud use Crosstable() in the load script to transform your data

 

Keep learning !

Cheers

 

GiuQlik7
New Contributor II

Re: Issue with distribution plot

Thank you christophebraul!
I continue my tests following your advice 🙂
GiuQlik7
New Contributor II

Re: Issue with distribution plot

I got what I wanted, thank you very much!