Wondered if anyone can help - I've searched the community and while I find many posts i cant find one that resolves my problem.
My data is organised by date for example:
Next month the table grows and I get new rows for the following month.
I want the page to open with the latest month's data on show but for the user to be able to select a previous months data if they wish.
I have this all working using the extension qsVariable, and set analysis using this variable but I have to go in every month and add the new values for the new date and I am looking for a way to automate this.
I have looked at using the extension qliksenselistbox but this makes a real selection and I only want to set a variable as I have other sheets that are similar but use different dates. In fact I have 4 different sheets all using different dates which is why I want to automate it.
I have seen that the qsvariable has a dynamic setting in values Value1|Value2 - but i do not know how to create the expression that would create 12/03/2018|12/02/2018|12/01/2018 from my table. I don't think I can use peek as I don't know how many different dates i will have in the table so cant set the row number
If anyone has any ideas how i can create the dynamic expression, or any other way of achieving this i'd be most grateful.