topic calculation condition or other filter ? in QlikView

calculation condition or other filter ?

Wed, 18 Jan 2012 14:21:52 GMT

Hello,

I have a table with columns : code_project (text), date, num (number), action (text), state (=1 or null).

I created one list box (to choose code_project) and one chart (number/date, no matter the state), and i want to add a table to show actions for the code_project selected, with state=1.

I tried with a Table box, with Calculation condition : state=1

but it does'nt work (if I add a list box on state and i select value 1, the table box is ok, but it is the chart which is not, because filtered !)

How to do correctly ?

Thanks !

Vincent

calculation condition or other filter ?

lironbaram — Wed, 18 Jan 2012 14:32:58 GMT

you can add to your chart expression set analysis {<state=>}

so the expression in the chart will disregard selection in the state field

calculation condition or other filter ?

Wed, 18 Jan 2012 15:24:36 GMT

I don't use a chart, but a table box, without "expression" tab, but with a "Calculation condition".

And if i try with a "straight table" chart, nothing appear...

Sorry, i'm a beginner, can you explain a little more ?

Thanks !

Vincent

Re: calculation condition or other filter ?

Sat, 28 Sep 2013 17:38:08 GMT

I have same issue but problem is that like yours when putting condition my data is limited to 2 million from 30 million. And with straight table it takes around 30GB RAM for 2 million rows and table box takes 1GB for 30 million rows.

did you find any solution