topic Re: Filtering a definition by using if or where clause? in QlikView

Filtering a definition by using if or where clause?

Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

i have a table and in its function i add a "Count" function.

COUNT(DISTINCT keyattribute)

This works. So in the end i get a table with values on the left side and frequencies on the right side.

Now i want to filter this table in a way that a "WHERE" Clause is predefines.

This wont work for me.(example how it did not work)

COUNT(DISTINCT keyattribute) WHERE filterattribute='sn'

Now i also tried doing it with a if CLAUSE:

if(filterattribute='sn', COUNT(DISTINCT keyattribute)

At least this variant was syntactically correct, but it does not show the results i want it to. Output is just an empty table (i mean no frequencies.)

Can anyone help me here?

Re: Filtering a definition by using if or where clause?

sunny_talwar — Tue, 23 Aug 2016 10:27:55 GMT

How about using set analysis:

Count(DISTINCT {<filterattribute = {'sn'}>} keyattribute)

Re: Filtering a definition by using if or where clause?

arulsettu — Tue, 23 Aug 2016 10:29:59 GMT

i think you missing closing bracket

try this

if(filterattribute='sn', COUNT(DISTINCT keyattribute))

count({<filterattribute{'sn'}>}keyattribute)

Re: Filtering a definition by using if or where clause?

Tue, 23 Aug 2016 10:59:24 GMT

Thanks a lot :-). This worked!