Table box on a button click

[#1]

Hi all,

I am again here with my small query.I want to populate my table box on a click of a button.

Scenario is like that,on loading I doesnt want to populate table box ie want to show it is as empty first .I have some filters(list boxes) and  a button on the qlikview report.user can select some values from these list boxes and then clicks the button.On clicking button, data sets filters out and then filtered data is shown in the table box.

How I can do it.I think we can use variables,but i am not sure how I restrict that table box doesnt populate on first load.Also how i can write script for button click.

Thanks in advance.

[#2]

HI,

Above qvw is useful to me,

and it is working on when selection on region.

but my question is if any field value selection then graph is appear

ThanX in Advance......

[israrkhan]

No, not any,

only Fields, that you will type in calculation condition, in this case Region.

IF(GetSelectedCount(Region)>0,1,0).... it will show chart when you will make selection in Region Field.

IF(GetSelectedCount(Region)>0 and GetFieldSelection(Month)>0,1,0), it will show the chart, when you will select a Region and Select a month as well.

and you can add more fields, if you need by adding AND in the expression.

Hope it helps...

[#4]

Israr,it is better to bring all dataset in one qvd(around 2-3 gb size) and then use this qvd file to populate charts after applying all the filters?Just I have to confirm with that it is permissible to me deploy such big qvd file.

Actually,it is my one month data only and also we are  fetching history.

Also there can be multiple rows basis on some fields but i need to show distinct records even after selection.

For you r 2nd sggection,actually I have two tables which I need to join.It causes cross joins because of many to many mappings.I cant reduce it because it gives me all  infor I want. So what I can do it,create two qvds for each table and join them on run time.

Secondly,I can create a single qvd file ,by popluating data created by cross joins and then use this qvd.

Which is better?

[israrkhan]

Generating one QVD is better option, because join on run time will also take time.

and as you said, you have 2, 3 GB Size. i cant say much about it, because dont know about your Systems Configurations.

i will recommend you to generate another thread about QVD Size and performance. so may be an experienced person can give you better answer.

one more suggestion: if you can spend few hours. take a test of both options,

and than decide which one performing better.

Best Of Luck...

[#6]

Hello israrkhan,

                         How to display Straight table, if I have multiple selections within Region field, i.e if I select two regions at a time the table must show its contents, how to write calculation condition for this to happen. I tried to use the condition similar to one that you have mentioned but it didn't work out, could you please help me out.

Thanks in advance!