topic Re: Re: Expressions tab - Count(Distinct PolicyNumber) in QlikView

Expressions tab - Count(Distinct PolicyNumber)

Fri, 31 Oct 2014 14:48:05 GMT

On the Expressions tab in the Chart Properties, I am Counting the number of Distinct PolicyNumbers, to get a policy Count. What can I do to exclude a certain type of policy. In SQL I would say where Description <> 'Umbrella'.

Re: Expressions tab - Count(Distinct PolicyNumber)

Fri, 31 Oct 2014 14:51:04 GMT

Use set analysis for example count({<PolicyNumber-={'APolicy'}>}distinct PolicyNumber)

Re: Expressions tab - Count(Distinct PolicyNumber)

MK_QSL — Fri, 31 Oct 2014 15:14:32 GMT

Count({<Description -= {'Umbrella'}>}Distinct PolicyNumbers)

Count({<Description = {'*'}-{'Umbrella'}>}Distinct PolicyNumbers)

Re: Expressions tab - Count(Distinct PolicyNumber)

Fri, 31 Oct 2014 15:32:59 GMT

This seemed to work. Thanks

Re: Expressions tab - Count(Distinct PolicyNumber)

MK_QSL — Fri, 31 Oct 2014 15:39:24 GMT

Kindly close the thread by selecting correct/helpful answer

Re: Re: Expressions tab - Count(Distinct PolicyNumber)

anbu1984 — Sat, 01 Nov 2014 02:01:51 GMT

Set NullInterpret='';

Load * Inline [

Description,PolicyNumbers

Umbrella,1

Fan,2

,3];

='Set Analysis doesnt include null Description:' & Count({<Description -= {'Umbrella'}>}Distinct PolicyNumbers)

='Set Analysis including null Description:' & Count({1-<Description = {'Umbrella'}>}Distinct PolicyNumbers)

='If:' & Count(Distinct If(Description <> 'Umbrella', PolicyNumbers))