topic Re: Table box on a button click in QlikView

Table box on a button click

Mon, 21 Jul 2014 07:17:38 GMT

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.

Re: Table box on a button click

vardhancse — Mon, 21 Jul 2014 07:22:52 GMT

based on button click if we want to display the table box:

we can create variables and write action on button like make variable value '1'

layout condition on table box only if variable value is'1'

coming to data filter.

after the data load, select the required filters from the list box.

then click on button

now the table box will display only the data based on filters

Re: Table box on a button click

Mon, 21 Jul 2014 07:23:26 GMT

Please send the qwd file

Re: Table box on a button click

rohit214 — Mon, 21 Jul 2014 07:29:57 GMT

Please check in qlikview example in "What New in Qlikview 11.qvw" in report tabs

Thanks

Rohit

Re: Re: Table box on a button click

vardhancse — Mon, 21 Jul 2014 07:35:21 GMT

Hi Please find the attached QVW file for reference.

Created 2 variables: vReportOn & vReportOff

Button: Action

Table box: Layout condition

List box for giving filters

Please mark as correct, if your requirement was done

Re: Table box on a button click

israrkhan — Mon, 21 Jul 2014 07:50:18 GMT

its simple,

You can use the 'calculation condition' property of chart.

right click to go properties >> general tab. in the calculation condition

type your condition like, if(GetSelectedCount(Region)>0,1,0)

and when user will select a Region than chart will be shown, other wise it will be empty, and by clicking error message button you can type a custom message to show user.

see the attached file, and images below.

Chart Properties:

i did it for Straight Table, but you can do same for Table Box...

No Selection, its empty

After making selection in Region Field..

Re: Table box on a button click

Mon, 21 Jul 2014 08:05:40 GMT

Ok thanks for all your reply. i am also thinking of use of straight table chart or pivot table.But I came to know that my dataset would be too large(may be 80-90 lacs records or more than this.) . So I am thinking not to bring the data set in memory first.First just populate my filters(lis boxes),which would be very less data.After selection of list boxes and clicking on button,hit the database and bring the data in memory based on filters selected.Then show this data on straight table. Sql server 2008 is the database which I am using.

I know by doing this I am violating the basic fetaure of qlikview,which is bring the data set first and then apply filters.

But I have to do it because of large dataset.

can you all please provide ,some soultion for this.

Thanks in advance.

Re: Table box on a button click

israrkhan — Mon, 21 Jul 2014 08:15:52 GMT

I think you should load all data first, and then use calculated condition to show data in chart.

untill user will not mak selection, the chart will not be calculated, and it will not impact on performance.

and you can ask user to make more selection, like in 10, 12 listboxes, after you can show the chart, once its become less like 4 , 5 hundreds rows.

and in calculation condition you can type multiple conditions, once user make 10, 12 selections, than show it...

......................

and the way you wrote, how you will handle if user change the selection...???

Kind Regards

Khan

Re: Table box on a button click

Mon, 21 Jul 2014 08:22:36 GMT

Thanks Israr.If the user change the selection ,he/she again has to click on BUTTON to see the changes happens,ie in backend again we have to hit the database.

In loading all the data first,you mean stores data in qvd file and then fetch the data from qvd file to memory to show in chart on clicking on a button?

and storing so big dataset on the deploying server is a good practice?May be I cant get so much space for my report as there many other reports also?

Hitting the database may be not a good way,but I need suggestion which would be better way to handle this situation?

Re: Table box on a button click

israrkhan — Mon, 21 Jul 2014 08:33:38 GMT

if the chart purpose is just to show a report, than its ok somehow. .. 🙂

but if the purpose is analysis of data, than in your case,

on each time user changes the seletion , you will hit the data source again(load from source again), and may be it will take 2, 4 minute or more to load data, and user will wait for 2, 4 minutes on each selections to view the chart...?

try these two option, if applicable..

1) if possible, you can load less data, as for 5, 6 month or 1 year data only.. dont load the historical if it is not much needed.

2) try to do your calculation in script, like grouping of data by year, by month, and by other dimension, so finally you will get less rows in document.

Kind Regards

Re: Table box on a button click

Mon, 21 Jul 2014 08:46:37 GMT

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......

Re: Table box on a button click

israrkhan — Mon, 21 Jul 2014 08:53:36 GMT

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...

Re: Table box on a button click

Mon, 21 Jul 2014 08:53:49 GMT

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?

Re: Table box on a button click

israrkhan — Mon, 21 Jul 2014 09:02:49 GMT

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...

Re: Table box on a button click

Wed, 29 Jun 2016 05:04:32 GMT

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!