topic Re: formula in QlikView

formula

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

Hello everyone

i want to show the percent of patients that their (send document date) -(discharge date) are greater than 21 to all patients

something like this:

if((A-B) >21 , Vsum=Vsum+1)

c=Vsum/totalpatients

i would appreciate if anyone can help me to write this formula

swuehl — Sat, 18 Jun 2016 08:52:10 GMT

Maybe something like

=Count(DISTINCT If( [SendDocumentDate] - [DischargeDate] >21, VisitID)) / Count(DISTINCT VisitID)

or in a chart context to ignore dimensions, use an additional TOTAL qualifier:

=Count(DISTINCT If( [SendDocumentDate] - [DischargeDate] >21, VisitID)) / Count(DISTINCT TOTAL VisitID)

Kushal_Chawda — Sat, 18 Jun 2016 10:17:32 GMT

Create the Flag in script like below

LOAD *,

if([SendDocumentDate] - [DischargeDate] >21,1,0) as Flag_Days

.....

FROM Table;

Now use below expression

=count(DISTINCT {<Flag_Days={1}>} PatientID) / Count( distinct total PatientID)

Anonymous — Sun, 19 Jun 2016 06:30:00 GMT

Thanks to reply

it should be correct but unfortunately didn't work.

Thanks anyway

Anonymous — Sun, 19 Jun 2016 06:31:22 GMT

Many Thanks Kushal