Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic dimension in Containers

Hello,

we got "bukets" for different Deal Sizes which we fill in the load script. Now my customer wants to change these bukets (or better the borders between them) with setting variables.

Has anyone an idea how this can be done? If the new dynamic dimension would only contain the values of one buket, it wouldn't be a problem, but having more of them I do not know how I can get to this.

Thanks

Peter

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See this blog post: Recipe for a Histogram

Or maybe this one: True Dynamic Bucketing in QlikView – Infinity Insight Blog


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Gysbert_Wassenaar

See this blog post: Recipe for a Histogram

Or maybe this one: True Dynamic Bucketing in QlikView – Infinity Insight Blog


talk is cheap, supply exceeds demand
rubenmarin

Hi Peter,

Supposing you have 3 variables to set the limits you can use something like:

=If([Deal Size] < $(Limit1), '<$(Limit1)',

If([Deal Size] < $(Limit2), '>=$(Limit1)<$(Limit2)',

  If([Deal Size] < $(Limit3), '>=$(Limit2)')))

If the buckets are of the same size you can create it using class function.

Hope this helps.

Not applicable
Author

Thanks,

but the problem is that the buckets shall be of diffrent sizes.

rubenmarin

My first proposal will fit with different size buckets but the second link provided by Gysbert is very flexible way to achieve this requirement, if I needed to do something like this I will try to go through that link.

Not applicable
Author

Yeah, the second link shows an approach that I'll customize to my needs