topic Re: adding sub category in QlikView

adding sub category

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

Dear All

As the example follows script

Description	Amount
Fixed Asset	1200
Depreciation	150
Total Net Asset	??????

i want to know how to get this adding command with description of Total Net asset.

sagara

Re: adding sub category

niclaz79 — Mon, 30 Oct 2017 09:35:14 GMT

Hi,

Exactly what you are after is not clear, however if you are looking at having Total Net Asset as a sum of the above lines in the script, it's very easy:

LOAD

[Fixed Asset],

[Depreciation],

([Fixed Asset] + [Depreciation]) as [Total Net Asset]

FROM ...

Re: adding sub category

avinashelite — Mon, 30 Oct 2017 09:40:19 GMT

If you have the Description and Amount as columns in your data set then ...

1.Add a straight table or Pivot table

2.Add the Description as the dimension

3. Expression sum(Amount) and enable show Expression total in straight table or partial sum in Pivot table