Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get products last change date

How i can get last date when product price was changed ? In this example 13.3.2017

table.png

5 Replies
sunny_talwar

Where are you trying to get this information? Script or front end? Can you share a sample?

Not applicable
Author

Front end.

What i need is straight table. Where is all product, whose price has been changed for more than 30 days ago

sunny_talwar

It might be easier if we can have a sample to play around with... would you be able to share a sample?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

Not applicable
Author

small amount data

sunny_talwar

Check the attached... I had to create a link table because the Date was not sorted in the ascending order of date... if you can sort it before hand in your qvd or create a master calendar before your load your qvd... this might work without the link table.