Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts!
i have this problem regarding filtering my sheet.
I have a table with 5 column:
The table is sorted by date, and i would like to filter all the sheet depending on the LAST 100 values of this table (therefore i cannot take a data range picker, because i want the last 100 rows, and dates arenot perfectly distributed). That's why I added the rowno(total) colummn, but I don't know what to do now.
I thought to a button that set a variable like (rowno<100) but i have no clue how to do that.
Experts! Could you please help me?
Thank you!
Hi Andrea,
You can select the dimension (rowno()) and give the largest and values(100) as I specified 2 in the below screenshot.
Hi Shiva, thank you for your fast reply,
two things:
Is it possible to do that?
Thank you again!
Sorry for that, Andrea.
In Qliksense for the actions we need to use Sense Navigation + Actions visualization extension for Qlik Sense from Qlikbranch. as mentioned in Finding, Installing, and Using Qlik Sense Visualization Extensions.
that's fine, i have already installed that extension, but i have no clue on how set the variable. Explaining my self:
How can I do? Thank you again
Can you share a sample qvf.?
here it is
Sorry, but can you also share sample data.
this is the data i used to build the sample, but i don't know how much are useful
thank you again