Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | ||||||||
Movement | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 |
IN | 523 | 1.093 | 2.033 | 597 | 1.580 | 1.342 | 1.949 | 1.009 |
OUT | 81 | 1.173 | (1.005) | (62.992) | (121) | (239) | 63 | 63 |
I want this kind of result:
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.
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
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