Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to conditionally display records in a straight table only which satisfies a condition.
I need to display only when Days_Flag='Y'. based on a date field.
Date field will contain multiple lines for same date.
Eg: If the date field has 5 rows and only 3 rows has the Days_Flag field satisfying the condition "Y", then I need to display those 3 rows. How can this be achieved?
you can use set analysis for the same.
e.g. if your expression is Sum(Sales)
change it to Sum({<Days_Flag={'Y'}>}Sales)
or you can use if statement in the Dimenson Tab
Krish, if either of the posts helped with your use case, please be sure to return to the thread and on the post(s) that helped, use the Accept as Solution button to mark the one(s) that helped, as this gives the posters credit for the help and lets other Community Members know what actually worked.
The only other thing I have for you is a link to the Design Blog area on Community where we have hundreds of posts from our internal experts on a wide range of topics that will likely come in handy. There are quite a few posts on Set Analysis just FYI if you decide to go down that path...
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett