Hi experts,
I get a logfile that gives me the status changes per part number on daily basis simlilar to:
Day | Part number | status |
01.01.2021 | 1 | red |
05.01.2021 | 1 | red |
10.01.2021 | 1 | yellow |
17.01.2021 | 1 | green |
The user wants to see something like in the picture: count on part numbers per day stacked by the status (red, yellow, green) (-ignore the blue lines etc for now).
![SwenWa_0-1612512999915.png SwenWa_0-1612512999915.png](https://community.qlik.com/t5/image/serverpage/image-id/48569i671DEE89E9F98A99/image-size/medium?v=v2&px=400)
Obviously at the moment I count the part number 1 only when there is a record on the day (e.g. 01.01.2021).
-> how can I manage it, that the part number 1 also counts on the days between the record days in the logfile e.g. 02.01.2021 (red) or 15.01.2021 (yellow) or 20.01.2021 (green)?
I thought of something like "valid from ..." - "valid to..." but I do not know how to manage this? Please help me 🙂
Thanks 🙂