Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

calculation condition or other filter ?

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

Tags (2)
3 Replies
lironbaram
Honored Contributor II

calculation condition or other filter ?

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

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

Not applicable

calculation condition or other filter ?

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

Not applicable

Re: calculation condition or other filter ?

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

Community Browser