topic Re: Filter data with a Count and Where clause in QlikView

Filter data with a Count and Where clause

Wed, 30 Jul 2014 12:42:56 GMT

Hi all!

The short way:

I need to add a column that filter table record by a slq count with condition on a particular field.

----------------------------------------------

The long way:

I've a report generated by a Graph object in QlikView.

The QlikView main script contains three tabs with several load statementes inside.

This script load data from multiple QVD.

The QVW that create all those QVD load data from sql tables.

I need to modify that graph by adding a column which records are calculated by the following query:

select count(*) from T where T.field=value

(therefore the where clause should countain another condition on a field belonging a table still not present inside QV data model)

What is the best approach to accomplish this task??

Any help will be greatly appreciated!

Thanks in advance!

Wed, 30 Jul 2014 12:52:32 GMT

I found this solution that add the following expression:

Sum(if(FILED='some_value', 1, 0))

can be a correct one?

What if a would add a condition on a filed belonging a table still not present in the QV data model?

Wed, 30 Jul 2014 12:55:26 GMT

Hi ,

You can restrict the record in the object level.

Ex:

Count(if(F1='Value',Value)

Thu, 31 Jul 2014 06:28:15 GMT

Thanks, I appreciate your reply..!

How can I solve the second part of my question?

kitanbelles — Mon, 16 Aug 2021 14:46:16 GMT

Hi,

What if I want to do not equals to