QlikView questions

[#1]

Hi,

I am new to QlikView. This might be a simple question for you all.

I am loading data form a SQL table and want to display the data in 3 table box objects. All three tables display the data from the same table, with a difference in selection criteria. First table shows records where 'Status is Active', second one shows the records where 'Status is Pending' and the third one shows records where 'Status is Closed'

I want to know where I can specify this condition in the table object.

Thanks in advance for your help.

Regards,

Murali

[#2 · Accepted solution]

You can't really put a filter on a table in QlikView.

You can filter the table by setting up your Expressions to only pull the data you want. Set Analysis is probably your best bet.

Something like:

Sum({<Status = {'Pending'}>} Sales)

Obviously, you will have to edit it to work with your fields and data.

[#3]

Hello Murali,

You have to use charts (straight table or Pivot Table) and then you can have your condition in your expressions.

Talha