Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
jozisvk11
Creator
Creator

PIVOT TABLE - if ??? or SET analyse ???

Hello friend, my start table is:

DATE          ID Item          Income/Expenditure          Amount

15.12.          T1015                    Income                         10

18.12.          T1015                     Expen                         -10

20.12.          T1015                     Expen                           5

15.2  .          T1017                    Income                         10

17.2.            T1017                     Expen                          10

20.11.          T1018                     Income                         50

21.11.          T1018                     Expen                           50

15.10.          T1019                    Income                         100

18.10.          T1019                     Expen                         -100

20.11.          T1019                     Expen                           80

15.2  .          T1020                    Income                          10

17.2.            T1020                     Expen                          10

20.11.          T1025                    Income                           50

15.10.          T1028                    Income                         200

18.10.          T1028                     Expen                         -200

And result which I need is to show minus amount, but I need to show also others rows for given Item. The result table, which I need should be:

DATE          ID Item          Income/Expenditure          Amount

15.12.          T1015                    Income                         10

18.12.          T1015                     Expen                         -10

20.12.          T1015                     Expen                            5

15.10.          T1019                    Income                         100

18.10.          T1019                     Expen                         -100

20.11.          T1019                     Expen                           80

15.10.          T1028                    Income                         200

18.10.          T1028                     Expen                         -200

Can you help me, how can I do it ??

Thnak you

1 Solution

Accepted Solutions
sunny_talwar

Check the attached

Capture.PNG

View solution in original post

3 Replies
sunny_talwar

May be this:

Dimensions

DATE

ID Item

Income/Expenditure

Expression

Sum({<[ID Item] = p({<Amount = {'<0'}>}[ID Item])>}Amount)

sunny_talwar

Check the attached

Capture.PNG

View solution in original post

jozisvk11
Creator
Creator
Author

It is OK. Thanks a lot my friend