Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
colville
Contributor
Contributor

Representation of changed items only

Hi,

I'm looking for a statement which will show me only the items which had their price changed between week 24 and week 25 and also show the previews price

Example:

Week 24                   

Category                    Price

Mobiles                     $ 256

Computers                $ 499

Monitors                    $ 50

Printers                     $ 30

Docking                    $ 17

Keyboards                $ 4

Mouse                      $ 3

Hard Drive               $ 16

Desk                        $ 80

Chairs                      $ 50

Week 25

Category                   Price

Mobiles                     $ 300

Computers                $ 497

Monitors                    $ 50

Printers                     $ 34

Docking                    $ 17

Keyboards                $ 3

Mouse                      $ 2

Hard Drive               $ 16

Desk                        $ 80

Chairs                      $ 55

1 Solution

Accepted Solutions
neelamsaroha157
Specialist II
Specialist II

Is this what you are looking for?

View solution in original post

1 Reply
neelamsaroha157
Specialist II
Specialist II

Is this what you are looking for?

View solution in original post