topic Re: dimenssion in chart in QlikView

dimenssion in chart

zturaiki — Mon, 24 Dec 2012 09:11:37 GMT

i have this table in the database Bill_Table:

The column in the table is as followiing

Payment Type Gross Amount Discount Amount Amount Patient Payable

The Value in the column Payment Type is : Insurance / Cash / Aramco / GOSI

I will create chart to calculate the net amount per payment type

Net amount = sum(Gross amount – discount amount – amount patient payable)

But for the insurance I have to calculate the amount twice :

Insurance = sum(Gross amount – discount amount – amount patient payable)

And

Co-Insurance = sum(amount patient payable)

So in the chart , the dimension will be the Payment type:

Insurance / Co-Insurance / Cash / Aramco / GOSI

The problem that I cannot get the Co-insurance separate from the Insurance …

Re: dimenssion in chart

Mon, 24 Dec 2012 09:24:21 GMT

Pls give the sample data for this.

~kabilan K

Re: dimenssion in chart

Mon, 24 Dec 2012 09:26:06 GMT

Dear Zain Ahmed.

can you provide a sample file so that we can help you.

Thanks,

Mukram.

Re: dimenssion in chart

jagan — Mon, 24 Dec 2012 10:34:26 GMT

HI,

How you differentiate Co Insurance and Insurance, is there any logic for that?

Please try below expression

If(PaymentType = 'Insurance', sum(Gross amount – discount amount – amount patient payable),

If(PaymentType = 'CoInsurance', sum(amount patient payable),

sum(Gross amount – discount amount – amount patient payable)))

Regards,

Jagan.

Re: dimenssion in chart

zturaiki — Mon, 24 Dec 2012 15:13:23 GMT

Co-Insurance = Sum(amount patient payable)

Insurance = sum(gross amount - discount amount - amount patient payable )

in aother words:

Insurance = sum(gross amount - discount amount -Co-Insurance )

the co-insurance is partial from the insurance

Re: dimenssion in chart

zturaiki — Mon, 24 Dec 2012 15:16:09 GMT

Attached is example of the data

Re: dimenssion in chart

Gysbert_Wassenaar — Mon, 24 Dec 2012 17:12:20 GMT

Use expressions for every payment type. See attached qvw

Re: dimenssion in chart

zturaiki — Wed, 26 Dec 2012 05:47:20 GMT

Thank you Mr.Gysbert Wassenaar

its work know ,,, good solution

just i make a little change , i took the expression like this

sum({<[Payment Type]={'INSURANCE'}>}[Amount Patient Payable])

without the dual ...

question : what is the use of function dual ?

Thank you ..

Re: dimenssion in chart

Gysbert_Wassenaar — Wed, 26 Dec 2012 09:50:34 GMT

You're right that the dual function isn't necessary here. I was first trying another approach and forgot to remove the dual again. What it does is create a value with both a textual and a numeric representation. That way you can use the numeric value to calculate with and use the text value for presentation.