Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
try this
goto--> properties -->Axes --> select expression ---> then select position(left/right)
I didn't get your idea how it can be helpful in "Out of logical Memory " type of error
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
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 ?
Hello Guys
I need help as I am not able to find any work around.
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...
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 ???