Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist II
Specialist II

Is this what you are looking for?

View solution in original post

1 Reply
Specialist II
Specialist II

Is this what you are looking for?

View solution in original post