topic Re: Hide text object when there is no data for current selection in QlikView

Hide text object when there is no data for current selection

ashis — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I have two text objects and it has if condition based that it shows up , it is working fine as expected.

However when I select any month that has no data in my transaction table , I still see those text objects.

How do I hide the text object when there is no data in my selection (for example If I select month of december'17)

Thank you,

Ashis

sunny_talwar — Fri, 13 Oct 2017 11:41:43 GMT

May a condition like this:

Count(TransactionID) > 0

Anil_Babu_Samineni — Fri, 13 Oct 2017 12:00:17 GMT

Or this? Go to Properties - Layout Tab - Enable the Condition then type like below

If(Sum(Sales) = 0, 0, 1)

ashis — Fri, 13 Oct 2017 12:19:15 GMT

Thank Anil for your reply. it worked.

ashis — Fri, 13 Oct 2017 12:20:39 GMT

Thank you for your reply Sunny, i did from Go to Properties - Layout Tab - Enable the Condition.