Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Display Differences by Period

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

3 Replies
Highlighted
Champion
Champion

Display Differences by Period

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)

OR

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

HOPE THIS HELPS

Highlighted
Not applicable

Display Differences by Period

Thank You Sunil; It is working

Highlighted
Champion
Champion

Display Differences by Period

why not you make it correct

so that it will consider as close discussion.