topic Re: Showing a table only visible when data is given in QlikView

Showing a table only visible when data is given

Fri, 12 Sep 2014 10:16:39 GMT

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

Re: Showing a table only visible when data is given

sushil353 — Fri, 12 Sep 2014 10:20:31 GMT

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

Re: Showing a table only visible when data is given

Michael_Tarallo — Fri, 12 Sep 2014 10:24:47 GMT

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

Re: Showing a table only visible when data is given

Fri, 12 Sep 2014 10:29:19 GMT

Hi Michael,

I meant for Qliqview. Thank you for the clearification.

Regards,

Re: Showing a table only visible when data is given

Fri, 12 Sep 2014 10:32:56 GMT

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,

Re: Showing a table only visible when data is given

senarath — Fri, 12 Sep 2014 10:38:36 GMT

Hi,

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

or try using Getfieldselection function as well.

thanx

Re: Showing a table only visible when data is given

Fri, 12 Sep 2014 10:50:40 GMT

It does work now.

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

Thank you

Re: Showing a table only visible when data is given

Fri, 12 Sep 2014 10:50:49 GMT

It does work now.

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

Thank you