Hi All,
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
Case 1:
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).
Case 2:
Source 1 Date
31-Mar-2020(Last Working day of previous Month)
Source 2 Date
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
Regards,
Gopikrishna CH
