Showing a table only visible when data is given

[#1]

Good day,

What I want is as follows.

I have a table with data in it, but that looks a littlebit crowdy, so I would like to put a blank text object above it, so that the data only pops up when a search request is given in and the specific table can show data.

This means that the text object turns invisible at the moment specific data can be shown in the table under it.

Is that possible?

Regards,

Kees-Jan van 't Hof

[sushil353]

Hi,

Yes it is possible..

Say you have a list box year and want to show the table once there is any selection on year field..

Go to table properties>Layout> show conditional and put condition

=if(getselectedcount(Year)>0,1,0)

HTH

Sushil

[Michael_Tarallo]

Hi KJ - point of clarification - do you mean for QlikView or Sense?

Sushil's response is in regards to QlikView, as Sense does not have show conditional properties for its objects.

Note that what you want can be done with the Mashup APIs, but this is more of a web development exercise.

Please let us know.

Mike T

Qlik

[#4]

Hi Michael,

I meant for Qliqview. Thank you for the clearification.

Regards,

KJ

[#5]

Dear Sushil,

I did put in the conditional value, but it doesn't show up.

It is meant for invoice values. If there is no invoice sent, it doesn't have to show up.

Now I did search on a invoice number which exists, but the table is still invisible.

Conditional value is =if(getselectedcount(Invoice_IncludingVAT)>0,1,0) 

any clue?

Regards,

KJ

[senarath · Accepted solution]

Hi,

try using(even though similar to above) =if(getselectedcount(Invoice_IncludingVAT)>0)

or try using Getfieldselection function as well.

thanx

[#7]

It does work now.

I had to made a relation to another table and its ok now.

Thank you

[#8]

It does work now.

I had to made a relation to another table and its ok now.

Thank you