topic Re: Minimise object if empty on selection in QlikView

Minimise object if empty on selection

mazacini — Wed, 18 Jul 2012 07:19:34 GMT

With certain selections, some of my charts are empty - there is no data to display.

Is there a way to automatically minimise these objects when they have no data (and automatically display when they do!)

Rgds

Joe

Wed, 18 Jul 2012 07:44:57 GMT

step 1: Go to properties of the object

step 2: Go to genral tab

step 3: Go to Calculate Condition

step 4: Use an if condition example if you are calculating sale in in you expression use If(Sum(Sale)>0,True(),Fales())

Regards

Rahul

mazacini — Wed, 18 Jul 2012 08:06:07 GMT

Hi Rahul

I have tried that, and it still displays my chart, but without headers, and with the message

"Calculation condition unfulfilled".

Before entering the condition:

After entering condition:

Rgds

Joe

Wed, 18 Jul 2012 08:25:35 GMT

Dear Joe, My wrong, try the same contidion in the Layout tab. Regards R

mazacini — Wed, 18 Jul 2012 08:54:48 GMT

Thanks Rahul

That worked!

Joe