Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to show the trends report with list of rating and its buyer count.
Whenever there is a change in the rating, we will receive the updated rating with decision date (i.e when the rating changes happended).
So the data would be like:
BuyerName | Date Decision Made | Rating |
---|---|---|
Buyer 1 | Dec 2017 | 4 |
Buyer 1 | Mar 2018 | 2 |
But in the trends report, i want to show as below:
Buyer Name | Date Decision Made | Rating |
---|---|---|
Buyer 1 | Dec 2017 | 4 |
Buyer 1 | Jan 2018 | 4 |
Buyer 1 | Feb 2018 | 4 |
Buyer 1 | Mar 2018 | 2 |
I have attached the sample report as well. Any help would be appreciated.
Thanks.
Look here to Generating Missing Data In QlikView
Thanks, let me have a look