topic Re: help needed with making dynamic selections in QlikView

help needed with making dynamic selections

hopkinsc — Wed, 25 Nov 2020 16:16:04 GMT

hi all.

i have a requirement to make some awkward selections, the outcome of this is to get NPrinting to produce an extract after making these selections, but first i want to get it working in QV before i can then look at doing it in NPrinting.

i have a field (Dataset) which holds mixed format values (text and numeric - text appended by period - XXXXXX FY17 201705), i need to make selections on these fields for the last 3 periods. it needs to be dynamic, so as periods change the selections also change.

i have created a button and was looking at getting an action to do this in the first instance, i can then look at using the syntax of that action for an NPrinting filter.

i have attached a example QVW and would appreciate it if someone could take a look and help, an example of what i need to do is in a text box in the QVW

many thanks

Re: help needed with making dynamic selections

swuehl — Thu, 24 Nov 2016 16:24:48 GMT

Maybe like attached?

Re: help needed with making dynamic selections

hopkinsc — Thu, 24 Nov 2016 20:12:22 GMT

Hi Stefan,

thanks for this, it works as needed within QV. i am trying to now get NPrinting to make the same selections and produce an extract but i cant get NPrinting to do the same thing.

I dont suppose you can help with this can you?

Re: help needed with making dynamic selections

swuehl — Thu, 24 Nov 2016 20:17:12 GMT

Sorry, I don't have much experience with NPrinting.

Any idea which part breaks (variables, search string, trigger)?

Re: help needed with making dynamic selections

hopkinsc — Thu, 24 Nov 2016 20:21:38 GMT

i cant get the variables to pass through, but i have it in my mind that QV variables don't work in NP.

i think NP can populate variables in QV but i dont think you can use variables from QV but im not 100% sure.

Re: help needed with making dynamic selections

hopkinsc — Thu, 24 Nov 2016 20:32:31 GMT

do you think its possible to get the same result but without using variables?

Re: help needed with making dynamic selections

swuehl — Thu, 24 Nov 2016 21:11:48 GMT

Do dollar sign expansions work in NPrinting?

Re: help needed with making dynamic selections

erikzions — Wed, 07 Dec 2016 15:55:05 GMT

Yes dollar sign expansions work in NPrinting. Make sure you tell it to evaluate. Also make sure that the variable is defined in Qlikview and not in Nprinting if you want to make multiple selections.