Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator II
Creator II

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