On-Demand Data Pull

[johnjustus]

Hi

I have an requirement like this.

I have an Listbox that contains list of dates.

When the user opens the QVW from AccessPoint, they will be presented just with the list box populated with list of dates (eg., Jan 2017, Feb 2017 and so on..) And the user will be displayed with an empty table (Date, Amount etc.,)

Now when the user picks a date from the Listbox, the empty table should be populated with data for the corresponding selected date.

How can I achieve this in Qlikview?

I am using Version : 11.20.12354.0 SR6

Thanks

[neelamsaroha157]

You can use calculated condition in your chart.

Something like in the attached file.

[johnjustus]

Hi Neelam,

Thanks for the information.

In your case, you are using an single table.

Mine is slightly different.

Lets say, I have one query as below which would bring in only the dates.

Select * from Date table

My another query would be the main table.

Select * from fact table

An join exists between these 2 tables on a field.

In terms of data display, I want to display the chart after I select the date from the list box. I don't want to pre-load the data rather I want to send live query for the selected date and then populate the chart with data

Is it possible?

Thanks

[neelamsaroha157]

Are you trying to achieve this via scripting?

If you have all the data loaded, i guess you'll get the same result as you are getting from your query.

The chart condition will pass on the date selection to you main table which you are trying to display in your chart.

[johnjustus]

Yes, scripting solution is fine.

Using an variable, I think we can pass a parameter to the second query and then the second query can bring in the data?

Theoretically I can think as I am new to Qlikview not sure how to implement.

If you can take that idea and put that in to QVW using 2 different spreadsheet that would be helpful if that approach make sense.

Thanks

[neelamsaroha157]

If you are passing values from a front end variable to script, then everytime you change the value, you'll have to reload data and it is not good idea to give permissions to end user for reload.

If you can share some sample data and the exact output, then it would be much easier to help .

[Digvijay_Singh]

It doesn't make difference whether you have single table or two tables as long as tables are associated through some field. I am afraid if you want to pull data from your source database directly in front end. ( In qlikview the usual process is to reload first, the data from sources in the data model and then use it in the front end, All the data always available with the application after reload).

You always reload your application when you need updated data from your source databases.

You would need to use direct discovery  features(Direct Query statement) if you are expecting automatic new data loading from your DW DB without manual reload.

The sample attached is based on two tables and show condition in the straight table.

[johnjustus]

Here is the attached dataset and also it shows the output what I am looking for.

The script can contain query or reference to both the Month table and the Fact table, however fact table should load only after selecting the month from the list box.

Yes, I understand that reload option should not permissioned to end users.

Please take a look and let me know how we can approach.

I appreciate your time sincerely.

[johnjustus]

Thanks for your time Vijay!

Agree on the usual process of Qlikview.

It looks like then there is no other way of achieving this req with out Direct Discovery.

Do you perhaps have an sample how it will work using Direct Discovery?

If you can give me an sample script then I will use 2 different excel files (Data on 1 file will be pre-loaded and data on the fact excel file will be loaded as on-demand) and will test how Direct Discovery works.

Thanks Again!

[#10]

You can try direct discovery option