Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
gopikrishnach
Creator
Creator

Variance Summary Dashboard in QlikView_Different Scenarios

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

 

1 Reply
alex00321
Creator II
Creator II

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