Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Translating Summary in Excel to an aggregated summary table in Qlikview?

Case NumberReason Denied 1- Missing InfoReason Denied 2- Contracting Issue Appeals MadeAppeals with response from insurance companyAppeals Won (Paid)Total Paid
110211$60
211100$0
310331$100
401111$60

I have created a summary table in Excel with Pivot tables and a few functions, and am struggling how to create the same information in Qlikview. Please note: Denials are binary (1 means we were denied for this reason; 0 means denial was not for this reason); 1 denial can have 2 denial reasons (as shown in Case 2)

The final summary table looked like this:

ReasonAppeals MadeAppeals with ResponseAppeals Won
Avg Paid per Appeal with Response

Reason 1 Denied- Missing Info

642$40
Reason 2 Denied- Contracting Issue211$60

How can I create this in Qlikview?

1 Solution

Accepted Solutions
sinanozdemir
Valued Contributor III

Re: Translating Summary in Excel to an aggregated summary table in Qlikview?

Hi,

I divided the main table into two tables and then concatenated them:

Capture.PNG

Capture.PNG

I am also attaching the qvw.

Thanks

5 Replies
sinanozdemir
Valued Contributor III

Re: Translating Summary in Excel to an aggregated summary table in Qlikview?

Hi,

I divided the main table into two tables and then concatenated them:

Capture.PNG

Capture.PNG

I am also attaching the qvw.

Thanks

Not applicable

Re: Translating Summary in Excel to an aggregated summary table in Qlikview?

Hello Sinan,

Thank you for your reply. From where are you getting the 'Denied Reason 1' field? Is this supposed to be 'Reason Denied 1- Missing Info?' When I run the script, I get an error.

sinanozdemir
Valued Contributor III

Re: Translating Summary in Excel to an aggregated summary table in Qlikview?

Hi,

Yes, "Denied Reason 1" field is "Reason Denied 1- Missing Info". I am actually taking your table and dividing it into two individual tables based on the denied reasons. Since all the columns are the same, QlikView is concatenating them into one table. In the last LOAD statement, I am eliminating the records that don't have relations to both with "Reason <> 0".

Maybe post your app so I can see what's going on.

Thanks

Not applicable

Re: Translating Summary in Excel to an aggregated summary table in Qlikview?

I got it to work yesterday, when I wrote it out. Thank you so much!

sinanozdemir
Valued Contributor III

Re: Translating Summary in Excel to an aggregated summary table in Qlikview?

No problem.

Thanks