Please help expert!!!! I am trying to write the proper syntax to model this file to produce a dashboard.

[Anonymous]

key	medtype	Transtype	depensed	wasteamt
0123456	Zanax	remove	1.5	-
0123456	Zanax	waste	-	1.2

this is how the file looks right now.

I am trying to get the file looking like this:

key	medtype	depensed	wasteamt
0123456	zanax	1.5	1.2

This is the output i want in qlikview.

I have been trying model the the file above, to look like the file below. I have not been successful in doing that. Any help would be gladly welcomed.

Thank you experts.

[sunny_talwar]

May be this:

LOAD key,

          medtype,

          Sum(depensed) as depensed,

          Sum(wasteamt) as wasteamt

FROM ...

Group By key, medtype;

[vishsaggi]

Script level you can use Sunny's script.

Load the script as is and

In the chart you can use straight table and add

Dimensions: key, medtype

Expressions: = Sum(depensed)

                    = Sum(wasteamt)

Like:

[saimahasan]

may be you can use

sum(if(isnull(depensed),0,depensed))

and

sum(if(isnull(wasteamt),0,wasteamt))

in your expression window.

[Anonymous]

Thank you so much, this really helped me.

[Anonymous]

Thank you

[Anonymous]

Thank you