Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
xarapre7
Creator II
Creator II

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

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.

7 Replies
oscar_ortiz
Partner
Partner

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

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

275438-1.PNG

Good luck

Oscar

YoussefBelloum
Champion
Champion

Hi,

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

just used the getselectedcount(your_field)>0

Regards,

Youssef

HELP.png!

oscar_ortiz
Partner
Partner

I forgot the count of ID's

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

See attached...

Thanks

Oscar

sudeepkm
Specialist III
Specialist III

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.

T275438.PNG

xarapre7
Creator II
Creator II
Author

Thank you!  It worked!

xarapre7
Creator II
Creator II
Author

Thank you!  This is helpful!

oscar_ortiz
Partner
Partner

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