Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

ferranpuchol
New Contributor

Select Possible Field (with conditional) Action onChange variable

Hey guys, i really need your help.

There is my problem:

I have 3 scenarios for compare sales: vs LastYear, vs Target1 and vs Target2.

The difference between them is that they have differents levels of aggregation.

For example:

Imagine the following structure of the Product Master:

PRODUCT GROUP

GROUP

FAMILY

PRODUCT (lower lever of information)

The info for LastYear is for PRODUCT, for Target1 is FAMILY and for Target2 is GROUP.

When Lastyear is selected i want to see the information for PRODUCT, but when Target1 or 2 are selected I need to see the information for their lower lever.

So, the problem is that i need to select all the possible values from their lower level and then clear the fields that are below their lower level.

I tried to use conditional clauses on the FIELD (for OnChange action) but i've read in some posts that QV doesn't allow us to do that.

So, do you have any idea for this issue?

Thanks in advance.

Ferran.

1 Solution

Accepted Solutions
rogerioqv
Contributor II

Re: Re: Re: Select Possible Field (with conditional) Action onChange variable

Ferran,

See if this is what you need!

Greetings.

5 Replies
rogerioqv
Contributor II

Re: Select Possible Field (with conditional) Action onChange variable

Ferran,

Share your document so we can help!

ferranpuchol
New Contributor

Re: Select Possible Field (with conditional) Action onChange variable

It's a heavy one... i'm trying to create a simple example...

Do you hace any idea to solve the issue?

Thanks!

ferranpuchol
New Contributor

Re: Re: Select Possible Field (with conditional) Action onChange variable

I tried to do it simple...

rogerioqv
Contributor II

Re: Re: Re: Select Possible Field (with conditional) Action onChange variable

Ferran,

See if this is what you need!

Greetings.

ferranpuchol
New Contributor

Re: Re: Select Possible Field (with conditional) Action onChange variable

Shit... in my original file I forget to put '' between the field name... that's the reason because it didn't work...

Thanks!

Community Browser