topic Re: out of virtual memory Problem in QlikView

out of virtual memory Problem

Mon, 25 Jun 2012 09:00:53 GMT

Hi Friends

i have created chart with 1 dimensions and 10 Complex expression.so how can i optimize it?

Here is the Sample Example:

Header 1	Header 2	Header 3	Header 4
ProductName	qty1	qty2	qty3
A	12	10	15
B	23	-13	34
C	45	-56	-10
D	89	77	12

i want to get the output like below:

I have to show only only the quantities which are below 0

Header 1	Header 2	Header 3	Header 4
B	-	-13	-
C	-	-56	-10

i have achieved the solution but it is throwing error like out of virtual memoy.

Is there any simple way to do this?

Please help me out of this Problem.

Thanks In Advance

Re: out of virtual memory Problem

Miguel_Angel_Baeyens — Mon, 25 Jun 2012 09:03:41 GMT

Hi,

That should be "as easy" as using ProductName as dimension and the following as expression:

Sum({< qty1 = {'<0'} >} qty1)

And the same for each of the other Headers:

Sum({< qty2 = {'<0'} >} qty2)

And so on

Hope that helps.

Miguel

Re: out of virtual memory Problem

Mon, 25 Jun 2012 09:29:45 GMT

Hi angel

thanks for your response

here the qty1 and qty2 and qty3 is the Expressions labels

how can i use ?

Thanks

suresh

Re: out of virtual memory Problem

Mon, 25 Jun 2012 09:45:37 GMT

hi Angel

here the Qty1,qty2,qty3 are Expressions .when i hide it in the presentation tab

and i have created the one more expression like if(qty1<0 or qty2<0 or qty3<0,qty1)

i am getting the whole row is null values .How can i avoid that Please help me out?

Thanks

Suresh

Re: out of virtual memory Problem

Miguel_Angel_Baeyens — Mon, 25 Jun 2012 09:51:51 GMT

Hi Suresh,

Just change the "qty1" label for the name of the field that is being aggregated in each expression.

Hope that helps.

Miguel

Re: out of virtual memory Problem

Mon, 25 Jun 2012 10:05:00 GMT

Hi Miguel

Qty1 Consists of Multiple Metrics with complex expression.so how can i solve it?

Thanks

Re: out of virtual memory Problem

Miguel_Angel_Baeyens — Mon, 25 Jun 2012 10:10:25 GMT

Hi,

Can you please elaborate? Without knowing the exact expression is hard to make an educated guess. Besides, you may try with the Column() function.

Column(1)

Will return the result in the first column, with no need to call the whole expression within:

If(Column(1) > 0, something if true, something if false)

Hope that helps.

Miguel

Re: out of virtual memory Problem

Mon, 25 Jun 2012 10:51:15 GMT

Hi Miguel

ItemName Inventory Qty Qty1 Qty2 Qty3 Qty4

Qty1 =sum(qty1)+sum(Ordered Qty1)

The condition here is if (Qty1>0,Qty1,0) as One more Expression(Qty1 Remain)

Qty2 =(Qty1 Remain)+sum(ordered Qty2)

Here one more expression is if (Qty2>0,Qty2,0) as One more Expression(Qty2 Remain)

Qty3 =sum(qty3)+sum(ordered Qty3)

Here one more expression is if (Qty3>0,Qty3,0) as One more Expression(Qty3 Remain)

Qty4 =(Qty3 remain)+sum(ordered Qty4)

Here in Straight table I have hided the , , ,

So for I get all the values

Now my intention is to get the only negative values ( have to show entire row if there is atleast one Negative value)

Becoz I have the hided Remaining Values(Qty1 Remain…….4) I am getting some unwanted Null rows .So i have to avoid that Null rows

Instead of that I have used the

Qty2= if (Qty1>0,Qty2,0)+sum(ordered qty2) By using this expression instead of using I am getting out of virtual Memory error

If I use the Qty1 remain as Label in my Qty2 =(Qty1 Remain)+sum(ordered Qty2) I cant achieve my solution because null rows are produced.

I hope you understood my problem

Thanks,

Sureshkumar.S