Bar chart help

mahitham — Wed, 25 Nov 2020 16:16:04 GMT

Hi,
Can any one please help me to derive Added, Removed and Renamed count on the trend like below based on below logic in the backend script.
Added:
Date 11-10-2019 is compared with Max Date i.e., 20-10-2019
So IDs 6,7,8,9,10,11 are added So count on Trend for Added is 6.
same like Date 15-10-2019 is compared with Max Date i.e., 20-10-2019
So IDs 8,9,10,11 added So count on Trend for Added is 4.

Removed :
Date 11-10-2019 is compared with Max Date i.e., 20-10-2019 here
ID=3 is removed so count on Trend for Removed is 1.

Renamed:
Date 11-10-2019 is compared with Max Date i.e., 20-10-2019 here
for ID=5,Name=E that's renamed as Name =M for ID=5 in 20-10-2019
so count on Trend for Renamed is 1.

Expected Output chart:

Please find the attached excel spread sheet.

Thanks in advance

Re: Bar chart help

Brett_Bleess — Wed, 04 Dec 2019 17:03:11 GMT

Mahitha, just FYI, there is no spreadsheet attachment on your post, just the image screenshot, which makes it a bit difficult for folks to try to play with things, as they would have to recreate that... I think further clarification may be necessary as well, as I cannot really follow what you are trying to do here, an example app or anything additional may help someone come up with some further guidance for you.

Regards,
Brett

topic Re: Bar chart help in QlikView

Bar chart help

Re: Bar chart help