topic Re: variables with Class function in QlikView

variables with Class function

Fri, 23 Oct 2015 18:49:22 GMT

I have a variable (the variable is the total of several other variables) called vPricperton. I would like to have a dimension for this but want to group the values. I was trying to use the Class function with increments of 50 to create a caclulated dimension but it does not appear to work

Class($(vPriceperton),50)

The calculation of priceperton is donein variables within the UI and do not want to modify the data model to create another dimension.

Re: variables with Class function

Oleg_Troyansky — Fri, 23 Oct 2015 19:05:31 GMT

Adam,

I'm afraid you misunderstand the use of the Class function and/or the variables.

- The variable holds a single value (numeric or textual)

- The class function can be applied to a field, such as Price. With the class function, the field values can be divided into equally sized buckets.

I'm afraid it's impossible to bucketize a single value returned by the variable, unless I missed something that needs to be added here...

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Re: variables with Class function

Mon, 26 Oct 2015 12:57:27 GMT

Allow me to clarify

I have an expression stored in a vriable that I would like to use as a claulted dimension. I am having issues getting the variable to work as a calculated dimesnion (have followed other threads on the topic and followed the syntax)

since my calcualted expression has multiple results (calculting price/ton) I would also like to somehow group the results as well

maybe the title was not the best and should have done a better job of explaining my requirements

Re: variables with Class function

jonathandienst — Mon, 26 Oct 2015 13:04:12 GMT

First develop the calculated dimension without using a variable. Once that is working correctly, you can convert to working with a variable quite easily.Doing it all in a single steps makes it hard to see what is not working correctly.

Re: variables with Class function

Mon, 26 Oct 2015 13:52:43 GMT

I know the variable calcualtion is correct becasue I am using the expression on other charts and I get the correct result - the issue is using the expression as a calcualted dimension.