Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am creating a Qlik Sense App which includes several tables. The SQL part is working good (I am using the editor), the joins don't give double rows.
Now my problem:
Our database consists of articles. Each article has several starting dates (and therefore end dates) for pricing.
My need is to create a Qlik table which shows the article with its todays price and the period that price is valid in. That is not that hard, using the fuction getdate().
Now I want to show the previous pricing conditions in the next rows. In my database I have one row for starting date and one row for end date.
I hope I could explaine what I need.
Thank you for your help.
Hi,
Depending on your data model maybe try Max & FirstSortedValue that can both take a parameter to give the nth value, so something like;
Cheers,
Chris.
Hi,
Depending on your data model maybe try Max & FirstSortedValue that can both take a parameter to give the nth value, so something like;
Cheers,
Chris.
Thank you, it works out perfectly.
Now, as I am getting further with my app, there has poped up another question:
The date and the price filds are measures now. But how can I filter by measures?
Thank you again!