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

I cant chat bcoz there is no such a facility here

Can u attach a sample...

Not applicable
Author

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.

vijay_iitkgp
Partner - Specialist
Partner - Specialist

why dont you use striaght table with calulated dimension  and use 1 as expression and hide it.

Not applicable
Author

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