Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

apply filters in chart type table

Hi Guys

I want to prepare a table "tab" having 4 columns namely

Week, Id , Status, Priority  [coressponding to each column there is a table in QV]

Each week contains so many Ids and each Id has a status and priority individually

I want to display this data in table and want to apply some conditions on Ids like only those Ids lies in between specific dates and having specifc status etc

Please not that Week is a customized column i.e concatenation of two fields.

What is the best approach to do it. Do we need to make dimension and expression structure or any different approach.

Thanks in advance.

13 Replies
sivarajs
Specialist II
Specialist II

u can use condition in dimension like

if((id='x' or id='y' or id='z') and (status='A' or status='B' or status='C'),id)

Sivaraj S

Not applicable
Author

I made Week and Id as dimension and other fields as expressions.

When i put conditions in Id then it is gving the error "Out of logical Memory ".

Actually processing is being performed on very large number of rows so its my guess due to this out of memorey error is coming.

So what to do to avoid this 

sivarajs
Specialist II
Specialist II

try this

goto--> properties -->Axes --> select expression ---> then select position(left/right)

Not applicable
Author

I didn't get your idea how it can be helpful in "Out of logical Memory " type of error

sivarajs
Specialist II
Specialist II

This is the case exists when large volume of data u want to display or if any non-relevant data associted with your dimension

I thought if we split the axes it might work

Try by aggregating the fields....

Please attach the sample

Not applicable
Author

You are right !!!

My main QV table having "Id" contains around 300 thousands of rows and I want to filter some rows

from those based on the constraints (this constraints fields belong to different tables).

How to aggregate the fields in this context I couldn't understand .

Can you please provide a example ?

Not applicable
Author

Hello Guys

I need help as I am not able to find any work around.

sivarajs
Specialist II
Specialist II

Aggr function groups all related data to your fieldname

aggr(GT,CaseID)-- This will give you the those case id having GT

This will avoid unrelevant data...

By this way we can reduce memory...

Not applicable
Author

I tried to implement as you suggested

aggr("Conditions here",Id)   then it is giving "-1" . Am I doing the right thing??

Actually I have two dimensions "Week(concatenation of two fields eg W1245)" and one is Id. I have "status" and "priority" as expressions. I explained the structure in my first post.

Structure should look like

W1245   167854   Clearence  High

Can we chat ???