Hiding a straight table and limit the no of rows to export

[xarapre7]

Hi QV Experts!

How can i hide a straight table when no 'Year' or 'Month' is selected from the filters?  In addition, I want to limit the no. of rows to be shown and exported.  Meaning, the table should be hidden if the count of rows exceeds a specified no. (in my attached example, hide the table if the count of row is >5).

Please see attached.  Thank you in advance for your help.

[oscar_ortiz]

You can create a condition on the layout tab of the chart:

GetSelectedCount(YEAR) > 0 or GetSelectedCount(MONTH) > 0

Good luck

Oscar

[YoussefBelloum]

Hi,

Here is a screen shot and the file attached with the solution in it.

just used the getselectedcount(your_field)>0

Regards,

Youssef

!

[oscar_ortiz]

I forgot the count of ID's

(GetSelectedCount(YEAR) > 0 or GetSelectedCount(MONTH) > 0) and Count(SRID) < 5

See attached...

Thanks

Oscar

[sudeepkm]

instead of hiding the whole chart and then displaying msg in a text object you can restrict the chart to display data only when the desired condition is fulfilled and also you can display a customize error message in the chart.

[xarapre7]

Thank you!  It worked!

[xarapre7]

Thank you!  This is helpful!

[oscar_ortiz]

Preciosa,

Not sure if you solved your issue.  But if you have would you mind closing the thread.

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks

Oscar