topic Re: select conditions before loading in QlikView

select conditions before loading

woshua5550 — Sat, 16 Nov 2024 01:39:16 GMT

Hello experts,

I have a simple question that I need to load data with dynamic filter conditions , for example

I'd like to select some ROIS round like '2016 Q4','2017 Q1' at front end and then reload the data, only '2016 Q4' and '2017 Q1' related data was needed

how should my load script looks like ?

Thanks

Re: select conditions before loading

Taoufiq_Zarra — Fri, 20 Dec 2019 08:36:19 GMT

Hi,

I will wait for of the other experts opinion, but what I propose to you is to use the button at the top (for example "evaluation"), I will add in addition to the actions that you put an action where I will add a 'VBScript' which saves the selection in a file (csv for example) then I will load the file in load script and I will filter on the values.

so the action of the button :
1-create the file which contains the selected list
2-reload the script

Re: select conditions before loading

woshua5550 — Fri, 20 Dec 2019 08:44:23 GMT

Hello

Thanks for your reply , I'm quite sure your solution would work

it would be perfect if we don't need to create any temp files, let's wait for other solutions

thanks

Re: select conditions before loading

Anil_Babu_Samineni — Fri, 20 Dec 2019 08:53:13 GMT

In Qliksense we have ODAG feature. But, In Qlikview i really not aware how it can be but @rwunderlich gave the hint from ODAG Possible in View Hope he will answer soon with the possibility

Re: select conditions before loading

rwunderlich — Fri, 27 Dec 2019 18:09:03 GMT

If you search QlikVIew ODAG you will find some examples and blogs. I have not built this myself so I don't have a favorite reference to point out.

-Rob

Re: select conditions before loading

Brett_Bleess — Thu, 26 Dec 2019 14:49:28 GMT

Just adding the following Design Blog post that may be of some further help on ODAG:

https://community.qlik.com/t5/Qlik-Design-Blog/Big-Data-with-Qlik-One-method-does-not-fit-all/ba-p/1474484

If you want to pursue that avenue in QlikView, I would recommend getting up with your account team to discuss, as you will likely need some help getting everything setup properly...

The following may be of interest too:

https://www.qlik.com/us/products/associative-big-data-index

Regards,
Brett