topic Re: Expression Syntax... in QlikView

Expression Syntax...

Anonymous — Wed, 03 Dec 2014 06:36:52 GMT

Hello,

What is the error in this syntax:

=Count({<[@Lead_Lead Type] = {"Student"}, @Lead_Status={"Submitted"}>}DISTINCT(%LEADID))

Its not working, giving all values 0.

pls suggest.

Re: Expression Syntax...

amit_saini — Wed, 03 Dec 2014 06:38:43 GMT

Hi,

The correct syntax is count(distinct Staff_Name)

Try with this.

Thanks,
AS

Re: Expression Syntax...

tresB — Wed, 03 Dec 2014 06:39:37 GMT

Syntax seems good. Problem could possibly be somewhere else. Can you share your sample qvw?

Re: Expression Syntax...

Anonymous — Wed, 03 Dec 2014 06:42:43 GMT

Tresco,

If I remove @Lead_Status from Set, its work fine.

But I have to add one expression which will show total forms....any other syntax?

Re: Expression Syntax...

its_anandrjs — Wed, 03 Dec 2014 06:44:21 GMT

Try this expression

=Count(DISTINCT {<[@Lead_Lead Type] = {'Student'}, [@Lead_Status] = {'Submitted'}>} [%LEADID] )

Note:- Also check your field name weather it is correct that you use expression seems correct.

Regards

Anand

Re: Expression Syntax...

tresB — Wed, 03 Dec 2014 06:48:14 GMT

If I remove @Lead_Status from Set, its work fine.

That means there is no data for the combination - [@Lead_Lead Type] = "Student" And @Lead_Status="Submitted"

Select lead type 'Student' in the list box, you probably won't see lead status 'Submitted' in the white(possible) color.

Re: Expression Syntax...

Anonymous — Wed, 03 Dec 2014 07:06:08 GMT

No,

Data is their. If I use [@Lead_Lead Type] = "Student" only and then selecting "Form" from list box its working fine and giving me correct data.

But If I m putting it into expression, its not working....

Re: Expression Syntax...

SunilChauhan — Wed, 03 Dec 2014 07:12:28 GMT

Count(DISTINCT {<[@Lead_Lead Type] = {'Student'}, [@Lead_Status] = {'Submitted'},fieldname={'Form'}>} [%LEADID] )

Re: Expression Syntax...

tresB — Wed, 03 Dec 2014 07:15:32 GMT

Can you share your sample qvw that demonstrates the issue(with explanation)?

Re: Expression Syntax...

PrashantSangle — Wed, 03 Dec 2014 07:24:47 GMT

Hi,

Debug your expression by trying following steps

Take @Lead_Lead Type,@Lead_Status,%LEADID in list box

select @Lead_Lead Type list box select Student and

@Lead_Status list box selct Submitted and then check

Is there any value in %LEADID list box.

and if possible kindly post those screen shot with selected parameter or share data with sample qvw

Regards