I have a data set, have time, floor number and value, also date
I use R and able to make it like this which is having each floor as one section and each date as one section
then still have Y axis as the Value and the big X axis as time line as follow
I try to use Qlik to do a similar thing. I just need line graph, only one variable. but I want to have each floor one section and ideally have each date as on section also
but currently i have this:
which means each all floor at the same place, if I add floor as the second dimension, i just get the different color. any suggestion I can do it?
attached the data file for your info