Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts!
I would like to filter all my data by the last 100 values of a field, how can i do it?
Explaining, i have a field Date, and a filed DeltaDate (today - date). i would like that all my sheet is filtered, when i need it, with the last 100 values (last 100 dates). Only using this number.
How can i do it? It would be nice to set a variable connected to a button, but i have no clue on the variable definition.
Thankyou!
May be create a counter field
RowNo() as Counter
and then use select in field on Counter with the following search string:
='>=' & (Max({1} Counter) - 100)
Hello Sunny! Thank you for your reply.
Just to be clear, should I insert in the load script the line: RowNo() as Counter?
Whith which specification? Could you please be more clear? I am pretty new to Qlik Sense
Thank you very much again!
Didn't realize this was Qlik Sense... I responded thinking this was QlikView... sorry about that
No worries! Do you know how to do that using Qlik Sense?
You want to remove all except the last 100 in the script or you are looking to filter on the front end?
For front end, you might be able to use an extension for select in field: Select in field extension - Qlik sense | Qlik Community
the logic will be the same where you will create RowNo() as Counter in the script and then select everything greater than Max({1}Counter) - 100
ok I will be more clear.
I had two ideas:
Ideas?
Thank you again