topic Display Differences by Period in QlikView

Display Differences by Period

Tue, 22 May 2012 06:35:19 GMT

I have a table with 3 fileds Customer Name, Period(Date), Balances

Sample

Customer Name Period Balance

A, 01-May, 100

A,02-May, 200

I would like to display this in a Straight Table/ Pivot Table as follows

Customer Name Balance(01-May) Balance (02-May) Diff

A, 100, 200, 100

Appreciate support

SunilChauhan — Tue, 22 May 2012 07:41:16 GMT

DIMENSION-> Customer Name

FIRST EXPRESSION

SUM(IF(Period ='01-MAY',Balance))

SECOND EXPRESSION

SUM(IF(Period ='02-MAY',Balance))

THIRD EXPRESSION

COLUMN(1)-COLUMN(2) IF YOU WANT (01-MAY BALANCE- 02-bALANCE)

COLUMN(2)-COLUMN(1) IF YOU WANT (02-MAY BALANCE- 01-bALANCE)

HOPE THIS HELPS

Wed, 23 May 2012 07:23:19 GMT

Thank You Sunil; It is working

SunilChauhan — Wed, 23 May 2012 07:28:25 GMT

why not you make it correct

so that it will consider as close discussion.