topic Re: Calculate difference between two rows of list box in QlikView

Calculate difference between two rows of list box

sujit_nath — Sat, 16 Nov 2024 01:43:30 GMT

I have a column containing 2 values which I am using as a dimension in my pivot table chart.

The chart has one expression. Now I want a third row to be added into that column that will be the difference of second -first row upon calculation.

Column1

feild1

feild2

feild2-feild1 (Currently I do not have this feild. I want to add this feild so data will be populated id I use this column1 as dimension)

gayathridevi24 — Thu, 12 Dec 2019 10:04:04 GMT

Hi Sujit,

Could you please provide some examples.

Jesh19 — Thu, 12 Dec 2019 13:42:45 GMT

Try checking the ValueList/ValueLoop concept.

Kushal_Chawda — Thu, 12 Dec 2019 14:18:45 GMT

Create one inline table in script as below

Load * Inline [
Dim
1
2 ];

then in chart add below dimension and measure

Dimension:

=pick(Dim,Column,'Field3')

Measure:

=pick(Dim,sum(Sales),sum({<Column={'Field2'}>}Sales)-sum({<Column={'Field1'}>}Sales))

sujit_nath — Fri, 13 Dec 2019 04:45:53 GMT

Hi Kush,

Thanks for the solution, I tried with Valuelist though, and this gives me my desired result.

sujit_nath — Fri, 13 Dec 2019 04:46:49 GMT

i Jesh,

I achieved the solution through this. thanks alot!!