topic Re: Chart properties enable conditional under dimension tab in QlikView

Chart properties enable conditional under dimension tab

bimala0507 — Thu, 17 Apr 2014 05:07:50 GMT

Hi:

Can anyone make me understand, how the enable conditional work in Chart. For me , I would like to restrict few materials not to appear on the report based on certain condition, can it be achievable?

E.g. I would like tp bring up only those materials who has an associated PO for current Year or previous Year.

Any help would be highly appreciated.

Thanks & Regards,

Bimala

Re: Chart properties enable conditional under dimension tab

jagan — Thu, 17 Apr 2014 05:29:05 GMT

Hi,

Enable Conditional helps us in dynamic show/hide of the dimension in the chart. Can you some sample file, so that it would be easier to provide solution.

Regards,

Jagan.

Re: Chart properties enable conditional under dimension tab

Thu, 17 Apr 2014 05:30:07 GMT

if its on the Expression basis than you can use conditional expression in this case you can write your condition in that and it will work according to that

Re: Chart properties enable conditional under dimension tab

Thu, 17 Apr 2014 05:39:20 GMT

If I understood correctly, I think you are looking for calculated dimension rather than condition. You can filter out some dimension values by expression in calculated dimension.

Re: Chart properties enable conditional under dimension tab

its_anandrjs — Thu, 17 Apr 2014 05:40:32 GMT

As i under stand you can use the SET analysis to include some set of records and exclude some set of records.

Re: Chart properties enable conditional under dimension tab

rajat2392 — Thu, 17 Apr 2014 05:46:50 GMT

Hi Bimala,

For your requirement, you have to give set modifier in expression. There will be no need of Enable Condition.

But for your knowledge, Enable condition is for just hiding and showing the chart as per the requirement. Generally we use enable condition to show 2 different charts at same place, faking as a single chart is showing 2 different things.

Re: Chart properties enable conditional under dimension tab

MK_QSL — Thu, 17 Apr 2014 06:26:14 GMT

Enable Condition is used to show/hide chart/tables based on certain condition.

Something like... if you want chart to be shown only if total qty is > 1000.. you can use SUM(Qty) >= 1000

To restrict some values from specific field, you need to use set analysis.

Consider that you have below script..

Load * Inline

[

Customer, Item, Qty

A, Apple, 100

A, Orange, 50

A, Banana, 40

B, Apple, 70

B, Orange, 20

B, Grapes, 140

C, Apple, 110

C, Grapes, 60

D, Cherry, 90

D, Apple, 120

E, Orange, 80

E, Banana, 45

F, Cherry, 100

];

Create a straight table

Dimension = Customer

Expressions

Total Qty purchased by Customer

SUM(Qty)

Total Apple Purchased

SUM({<Item = {'Apple'}>}Qty)

Total Apple and Cherry Purchased

SUM({<Item = {'Apple','Cherry'}>}Qty)

Total Qty Purchased except Apple

SUM({<Item -= {'Apple'}>}Qty)

Total Qty Purchased for customers who have purchased Apple Also

SUM({<Customer = P({1<Item = {'Apple'}>})>}Qty)

Total Qty Purchased for customers who haven't purchased Apple

SUM({<Customer = E({1<Item = {'Apple'}>})>}Qty)

Hope this will help...

Re: Re: Chart properties enable conditional under dimension tab

bimala0507 — Mon, 21 Apr 2014 04:22:48 GMT

Hi:

I am hereby attaching the qvw. My requirement is to restrict certain materials to appear in the chart based on certain condition. Refer Report sheet. Unit Price Comparison report (2012-2013), Can see few materials who does not have any value but still appears

The condition used is

(len(PO_2013) <> 0 OR len(PO_2012) <>0,MATNR,Null())

So putting NULL value, when the condition not satisfied.

And enable the button suppress null values check box.

Thanks & Regards,

Bimala

Re: Re: Re: Chart properties enable conditional under dimension tab

jagan — Mon, 21 Apr 2014 05:23:04 GMT

Hi,

Try this three as dimensions

=IF(len(PO_2013) <> 0 OR len(PO_2012) <>0,WERKS,Null())

=IF(len(PO_2013) <> 0 OR len(PO_2012) <>0,MATNR,Null())

=IF(len(PO_2013) <> 0 OR len(PO_2012) <>0,MAKTX,Null())

Regards,

Jagan.