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.
I cant chat bcoz there is no such a facility here
Can u attach a sample...
This information is confidential from company's point of view. So I am not able to share my qlikview files
Can you provide something without sample.
why dont you use striaght table with calulated dimension and use 1 as expression and hide it.
Dear Vijay
I am using straight table with calculated dimension, but main problem is my data volume is very large
so it is becoming very heavy process to perform these conditions over that 3 lacs rows and giving out of memory error
You can refer this thread chain for complete problem