topic expression for dynamic dimension limitation on cyclical group? in QlikView

expression for dynamic dimension limitation on cyclical group?

Tue, 02 Aug 2011 20:05:19 GMT

I have a cyclical group with four dimensions, each with 10 to 20 values. Some data rows don't have values for these dimensions so they are grouped in the null ('-') value and can be significant enough to alter the scale of the axis.

I was wondering if someone knows how to dynamically calculate the number of values in the dimensions for the cyclical group?

Thanks,

Jimmy

expression for dynamic dimension limitation on cyclical group?

Wed, 03 Aug 2011 01:22:24 GMT

Hi Jimmy ,

I think you can limit it by using a expression instead of giving a value .

can you try using count() function , if it's not working in a chart try to calculate the count into a variable & use that variable there .

If still you are getting the same issue let me know i'll try in someother way ...

Thankyou

Meher