topic Re: Variance Summary Dashboard in QlikView in QlikView

Variance Summary Dashboard in QlikView

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

Hi All, I have to create a summary Variance Dashboard by comparing the values in two different sources. Here i am attaching the spread sheet contains the sample Raw Data, Sample Variance Dashboard and Sample Summary Variance Dashboard. Please review the attached spread sheet and help me to resolve my issue.

I already created the Sample Variance Dashboard, but stuck in creating of Sample Summary Dashboard. Please help me, how to build this report in Front End.

Re: Variance Summary Dashboard in QlikView

alex00321 — Tue, 14 Apr 2020 08:17:43 GMT

Hi, this is an interesting question, so in your scenario, will you have more systems? Now you only listed 2 systems. Thanks!

Re: Variance Summary Dashboard in QlikView

gopikrishnach — Tue, 14 Apr 2020 09:09:00 GMT

Hi Alex,

No, In my scenario I have only 2 systems.

Re: Variance Summary Dashboard in QlikView

alex00321 — Wed, 15 Apr 2020 03:11:48 GMT

Hi, I use attached app to resolve this, can you try if this works? Thanks!

Re: Variance Summary Dashboard in QlikView

gopikrishnach — Mon, 20 Apr 2020 13:57:36 GMT

Hi Alex,

The code is working fine, thank you so much for your help.

I have another scenario like, i have to compare Source 1 data with Source 2 Data in different dates, below is the example.

Case 1:

Source 1 Date

01-Apr-2020(every month Constant)

Source 2 Date

04-Apr-2020, 05-Apr-2020, 06-Apr-2020.....Etc(After 3rd 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

04-Apr-2020, 05-Apr-2020, 06-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.

Re: Variance Summary Dashboard in QlikView

alex00321 — Wed, 22 Apr 2020 01:18:20 GMT

Hi this is not clear to me. Also if my answer resolved your question firstly, then you could mark this as resolved and then open another question and I will try to resolve once you expand your detail. Thanks!