Continuation of my previous question,(https://community.qlik.com/t5/New-to-QlikView/Variance-Summary-Dashboard-in-QlikView/m-p/1695475#M38...), i have another scenarios like below
Source 1 Date
01-Apr-2020(every month Same Date)
Source 2 Date
06-Apr-2020, 07-Apr-2020, 08-Apr-2020.....Etc(After 5th of every month any date, we have to take for source 2).
31-Mar-2020(Last Working day of previous Month)
06-Apr-2020, 07-Apr-2020, 08-Apr-2020.....Etc(After 3rd of every month any date, we have to take for source 2).
I used Alternate state in the variance Dashboard creation, please help me out, how to calculate the count of match and no match accounts, if the both source source system having different dates.
Please find the attached spread sheets contains the detail and sample data
Hi, I think we'd better update the data structure first and then go back to qlik. Thanks!