I would like to select a value directly on table via formula.
I explain the goal. I would like to avoid "Bookmarks" because I would like to create only one story with all sheets.
I've different sheets on Qlik Sense with same chart, the only thing that change is the name of application. In order to filter the name of application I've created a table with the name of table using.
Like that : Name_of_Application='TOTO'When I do that I've 2 values on my table : "-1" & "0". Here I would like to keep only -1 value. And I would like to do that in formula directly.
I'm not sure if I was clear, do you have any idea ? 🙂
Thanks for your reply, In fact, when I said : "As bookmarks" it's because when I select on application on my able, the filters are created for all sheets. Then it's very complicated to imlement a story for all application.
My goad is : To have 8 similar sheets for 8 differents applications in order to create a story for all of those sheets on one shot.
Where can I put this : If(Match(Field, -1), Field) ?