Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
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