Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

expression for dynamic dimension limitation on cyclical group?

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?

dimensions.jpg

Thanks,

Jimmy

1 Reply
Not applicable
Author

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