topic Re: dynamic filter in script in QlikView

dynamic filter in script

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

Hi Folks,

i have a question:

my script does look like

load

ID,

Variante,

Re: dynamic filter in script

sunny_talwar — Wed, 29 Mar 2017 11:01:20 GMT

You can use variables... do you intend the user to decide if they want to pull Category 1 or Category 2?

Re: dynamic filter in script

Anonymous — Wed, 29 Mar 2017 11:01:38 GMT

Variable = 0/1

Where Category = $(Variable)

Variable = 'Caterory = 1'

Where $(Variable)

Re: dynamic filter in script

beck_bakytbek — Wed, 29 Mar 2017 11:07:36 GMT

Hi Sunny,

thanks a lot for your feedback, yes, i want to indent to decide by users to pull Category between 1 and 2

Re: dynamic filter in script

beck_bakytbek — Wed, 29 Mar 2017 11:09:12 GMT

Hi Shiva,

thanks a lot for your feedback, can i do that dynamicly?

Re: dynamic filter in script

sunny_talwar — Wed, 29 Mar 2017 11:11:04 GMT

Create a variable inputbox on the front end (lets call this vVar) and then use this in your where statement

LOAD ....

FROM ....

Where Category = $(vVar);

Re: dynamic filter in script

beck_bakytbek — Wed, 29 Mar 2017 11:15:13 GMT

Sunny,

i have a question, can i create a query at the beginning of script like:

if vVar = 1 then

load

...

only Values with 1

and if vVar = 2 then

load...

only Values with 2

is that possible?

thanks a lot

Re: dynamic filter in script

sunny_talwar — Wed, 29 Mar 2017 11:16:44 GMT

I think you should be able to...

Re: dynamic filter in script

beck_bakytbek — Wed, 29 Mar 2017 11:19:07 GMT

Thanks a lot Sunny

Re: dynamic filter in script

Anonymous — Wed, 29 Mar 2017 11:25:05 GMT

Yes Beck, You can use the Variable and pass values to it.

Re: dynamic filter in script

PrashantSangle — Wed, 29 Mar 2017 11:25:07 GMT

Hi,

various way to achieve it.

maintain excel which have filter fields and value.

then in Load first load excel table then load your table with where exists()

Excel:

Load Category from excel;

QVD;

Load * from table where exists(Category)

2: Using variable

Pass value to variable in batch (for that you have little knowledge on windows command or google )

Regards,

Prashant

Re: dynamic filter in script

beck_bakytbek — Wed, 29 Mar 2017 11:45:20 GMT

Prashant Thanks a lot for your feedback

Re: dynamic filter in script

beck_bakytbek — Wed, 29 Mar 2017 11:48:31 GMT

Hi Shiva, thanks a lot for your feedback,

can you show me your example of this issue?

thanks