topic Re: Expression in QlikView

Expression

upaliwije — Sat, 14 Jun 2014 17:04:57 GMT

Hi Friends

count(DISTINCT({<DAY = {">20"}>}[POLICY_No]))

Can some help me to rewrite the above expression in the correct way

Re: Expression

swuehl — Sat, 14 Jun 2014 17:25:35 GMT

Doesn't look too bad, if DAY is a field with numbers.

Maybe check the brackets:

=COUNT({<DAY = {">20"}>} DISTINCT [POLICY_No])

Re: Expression

eduardo_sommer — Sat, 14 Jun 2014 17:29:36 GMT

The ( after DISTINCT does not exist

Eduardo

Re: Expression

maxgro — Sat, 14 Jun 2014 17:36:39 GMT

maybe

count(DISTINCT ({<DAY = {">20"}>} [POLICY_No] )) // original

count(DISTINCT {<DAY = {">20"}>} [POLICY_No] ) // modified

Re: Expression

MK_QSL — Sat, 14 Jun 2014 19:11:35 GMT

Try

Count({<DAY = {">20"}>}Distinct [POLICY_No])

Re: Expression

upaliwije — Sun, 15 Jun 2014 06:06:33 GMT

Thanks all

But none of the expression is working

Re: Expression

ashfaq_haseeb — Sun, 15 Jun 2014 06:19:55 GMT

Hi,

Can you post your sample application?

Regards

ASHFAQ

Re: Expression

its_anandrjs — Sun, 15 Jun 2014 06:26:40 GMT

Hi,

Let me explain this, but how this possible all the expression suggest are right please see the small example for understanding with small table and this data is dummy data.

Source:

LOAD * Inline

[

DAY, POLICY_No

20,15482

20,15863

10,145896

40,158456

30,125639

15,258741

12,256923

13,245855

];

And in the straight table take

Dimension:- DAY

Expression:- Count(DISTINCT {<DAY = {">20"}>} [POLICY_No] ) // If DAY has numeric values

Re: Expression

upaliwije — Sun, 15 Jun 2014 06:34:58 GMT

Hi Anand

Thanks. What you say is correct and my below expression is working very well.

sum({<DAY = {">20"}>}[AMOUNT])

But this one is not working

Count(DISTINCT {<DAY = {">20"}>} [POLICY_No] )

Pls help

Re: Expression

ashfaq_haseeb — Sun, 15 Jun 2014 06:39:41 GMT

Hi try this.

Count({<DAY = {">20"}>} DISTINCT [POLICY_No] )

Regards

ASHFAQ

Re: Expression

upaliwije — Sun, 15 Jun 2014 06:44:28 GMT

Hi Ashfaq

sum({<DAY = {">20"}>} distinct [AMOUNT])

The above is working but What I want is count the policy No

Re: Expression

ashfaq_haseeb — Sun, 15 Jun 2014 06:49:27 GMT

Hi,

Can you please share your sample app.

Regards

ASHFAQ

Re: Expression

upaliwije — Sun, 15 Jun 2014 06:58:34 GMT

Thanks Ashfaq,

Sorry I am unable to do it

count({<DAY = {">20"}>}[POLICY_NO])

This expression is also working . But the question is when DISTINCT is added to the Expression it is not working

Re: Expression

its_anandrjs — Sun, 15 Jun 2014 07:09:23 GMT

Can you share some sample data.

Re: Expression

Sun, 15 Jun 2014 12:20:03 GMT

Hi Upali

Use single quotes instead of double

Count({<DAY = {'>20'}>} DISTINCT [POLICY_No] )

Regards

Padma

Re: Expression

swuehl — Sun, 15 Jun 2014 12:41:50 GMT

What do you mean with 'not working'? What is the result you get and what do you expect?

As mentioned several times before, it would really be helpful if you could post more details about your model and data and what you want to achieve. Best by posting a small sample app that demonstrates your issue.