topic Formula with Valuelist in QlikView

Formula with Valuelist

Tue, 26 May 2009 18:58:37 GMT

Hi,

I have created a pivot-table with a synthetic dimension via the valuelist function. Now I am trying to reference a formula (i.e. sum(a) ) to a dimension value (i.e. 1, 2, 3, 4), but I dont know what I have to to.

The manual says:

"In charts with a synthetic dimension created with the valuelist function it is possible to
reference the dimension value corresponding to a specific expression
cell by restating the valuelist function with the same parameters
in the chart expression."

I dont understand what is meant exactly with "restating"?

Lets say I want reference the dimension value "1" to the formula "sum(a)". How can I do this?

Formula with Valuelist

Tue, 26 May 2009 19:57:53 GMT

Hi,

It is quite simple. Say you use a function ValueList(1,10,100) as your dimension. In the Expression, you want to print 'Yes' only when the Value of ValueList is 10. You can put the following as Expression to do this:

If(ValueList(1,10,100)=10,'YES','NO'))

So, effectively, by just using the same Valuelist (restating), you could get the value for the current row.

Formula with Valuelist

Fri, 19 Jun 2009 19:33:45 GMT

I understood and it makes sense.

However, I get an "allocated memory exceed" error in my application. So i created a new blank application just to try the code you gave me up there ... Still allocated memory exceeded. Is there any help?

Here is the test file I created:

http://rapidshare.de/files/47589440/test.qvw.html

Could somebody please open this and tell me whether they get the same error?

Best regards,

Robert

Formula with Valuelist

Fri, 19 Jun 2009 19:46:08 GMT

Hi Robert,

I can able to open and see the application.

- Sridhar

Formula with Valuelist

Fri, 19 Jun 2009 21:15:30 GMT

thanks for testing it ... i just talked to the support ...

It is a know BUG of 7.52 and they told me to get an upgrade. However, this is not possible since our IT does not want to upgrade hundreds of PCs. So I will use LOAD INLINE to create this dimension in a seperate table!