Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
GiuQlik7
Contributor II
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.

Labels (4)
1 Solution

Accepted Solutions
christophebrault
Specialist
Specialist

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

 

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin

View solution in original post

3 Replies
christophebrault
Specialist
Specialist

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

 

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
GiuQlik7
Contributor II
Contributor II
Author

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

I got what I wanted, thank you very much!