topic Re: conditionally display a table based on value in QlikView

conditionally display a table based on value

Krish — Sat, 16 Nov 2024 19:29:02 GMT

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?

Re: conditionally display a table based on value

dplr-rn — Tue, 10 Dec 2019 17:17:42 GMT

you can use set analysis for the same.

e.g. if your expression is Sum(Sales)

change it to Sum({<Days_Flag={'Y'}>}Sales)

Re: conditionally display a table based on value

yassinemhadhbi — Tue, 10 Dec 2019 19:37:21 GMT

or you can use if statement in the Dimenson Tab

Re: conditionally display a table based on value

Brett_Bleess — Tue, 17 Dec 2019 21:40:10 GMT

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