Hi Everyone - Being new to Qlik, I am trying to do the following and struggling with it, seems like a trivial issue
I have data something as below, where tracking ID remains same for multiple sequences. e.g. 1002 has 4 sequences, 1003 has only 1.
I want to use this data to create charts where i want to use say a condition that only those rows get picked up where Sequence Number = 1. How do I do that?
I can use the Filter Pane on sheet but i want that it should be independent of any filters, and condition exists somewhere in the expression itself. Please suggest.
This works, just another query if I want to have multiple filters, say in the above data Sequence Number = 1 AND Month = Mar-22, how do I write that? AND function doesnt seem to work.
Hi, You can use set analysis Sum({<[Sequence Number]={1}>}yourmeasure)
Regards, Vitalii
Press LIKE if the given solution helps to solve the problem. If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").
This works, just another query if I want to have multiple filters, say in the above data Sequence Number = 1 AND Month = Mar-22, how do I write that? AND function doesnt seem to work.
