topic Re: Calculated Dimension in QlikView

Calculated Dimension

Mon, 22 Apr 2013 03:19:29 GMT

Hi all,

I have data in two dimensions as below.

Doc Type-------------------- Amount

INV 2313

INV 234123

DN (2321)

INV 1123

DN (123)

I want to take INV sums in one column and DN sums in other column and then Gross Profit (Calculated Dimension) in third column.

Please advise.

BR,

SAK

sreenivas — Mon, 22 Apr 2013 05:47:56 GMT

PFA of the File .

Mon, 22 Apr 2013 05:54:43 GMT

for first expression

sum(if(Doc Type='INV',Amount))

2nd expression

sum(if(Doc Type='DN',Amount))

kaushiknsolanki — Mon, 22 Apr 2013 05:55:54 GMT

Hi,

Try to create a straight chart with following expression.

Dont need to have dimention in your case.

1. Sum({<Doc_Type = {"INV"}>}Amount)

2. Sum({<Doc_Type = {"DN"}>}Amount)

3. column(1) - column(2) for gross profit.

or else

Sum({<Doc_Type = {"INV"}>}Amount) -

Sum({<Doc_Type = {"DN"}>}Amount)

Regards,

Kaushik Solanki

sushil353 — Mon, 22 Apr 2013 06:08:31 GMT

Hi,

Is it what you are looking for.

Please find the attached file

HTH

Sushil