topic HOW TO MANIPULATE PRODUCT_TYPE TABLE? in QlikView

HOW TO MANIPULATE PRODUCT_TYPE TABLE?

Wed, 16 Mar 2011 01:11:30 GMT

I have a PRODUCT_TYPE table, whic has CHOCOLATE and STRAWBERRY in it. Each of this 2 products has a selling price table, which includes the FOB, CIF, ENDUSER, BP so and and so forth.

1) When i click the CHOCOLATE table, i want the selling price table of he CHOCOLATE component to come out.

2)When i click the STRAWBERRY table, i want the selling price table of the STRAWBERRY component to come out, at the same time, for the CHOCOLATE selling price table to get minimized.

3) When i click the CHOCOLATE table, i want the selling price table of he CHOCOLATE component to come out, at the same time for the STRAWBERRY selling price table to get minimized.

(The selling price table is a CHART by the way)

Is there any way for me to accomplish this ? Using triggers?

HOW TO MANIPULATE PRODUCT_TYPE TABLE?

jonathandienst — Wed, 16 Mar 2011 06:13:03 GMT

You don't need to use macros or triggers, I would suggest conditional display for the chocolate and strawberry tables. The show condition would be something like:

=wildmatch(GetFieldSelections('product_type'), 'CHOCOLATE') > 0

and

=wildmatch(GetFieldSelections('product_type'), 'STRAWBERRY') > 0

This is fine if you have a couple of tables, but less so if there are a lot of these tables.

If you could possibly have more than 6 product_type selections active at any time, then you will need to modify the expressions:

=wildmatch(GetFieldSelections('product_type', ',', nnn), 'CHOCOLATE') > 0 where nnn is the maximum number of prodcut_type selections you want to be able.

Jonathan

HOW TO MANIPULATE PRODUCT_TYPE TABLE?

Wed, 16 Mar 2011 07:00:55 GMT

Hello Jonothan,

Where do i put the commands inside ?

=wildmatch(GetFieldSelections('product_type'), 'CHOCOLATE') > 0

and

=wildmatch(GetFieldSelections('product_type'), 'STRAWBERRY') > 0

Where do i put those commands under ?

Thanks!

HOW TO MANIPULATE PRODUCT_TYPE TABLE?

jonathandienst — Wed, 16 Mar 2011 07:15:11 GMT

For each of the charts: Properties | Layout tab, Show Conditional

Jonathan

HOW TO MANIPULATE PRODUCT_TYPE TABLE?

Wed, 16 Mar 2011 08:28:00 GMT

Hello Jonathan,

I tried putting in the 2 formulas. But i don't understand what is the function of it ? as in, what do these formulas do, or what are they supposed to do ?