Variance Summary Dashboard in QlikView_Different Scenarios

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

Hi All,

Continuation of my previous question,(https://community.qlik.com/t5/New-to-QlikView/Variance-Summary-Dashboard-in-QlikView/m-p/1695475#M388211), 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

Re: Variance Summary Dashboard in QlikView_Different Scenarios

alex00321 — Wed, 13 May 2020 08:57:06 GMT

Hi, I think we'd better update the data structure first and then go back to qlik. Thanks!

topic Variance Summary Dashboard in QlikView_Different Scenarios in QlikView

Variance Summary Dashboard in QlikView_Different Scenarios

Re: Variance Summary Dashboard in QlikView_Different Scenarios