Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Writing syntax

Can you please help me write a set analysis expression for the following problem.

Table contains fields : Bill no. , Customer name and invoice amount

I would like to query the total invoiced amount for customers who have only one invoice against their name.

thank you

1 Solution

Accepted Solutions
Not applicable

Re: Writing syntax

I think you need []

SUM({<Customer ={"=Count(DISTINCT [Bill #])=1"}>} [Invoice Amount])

8 Replies
Not applicable

Re: Writing syntax

=SUM({<custumer={"=Count(DISTINCT billno)=1"}>} value)

Not applicable

Re: Writing syntax

Thank you so much for your prompt reply.

i used the following as these are the exact field names

SUM({<Customer ={"=Count(DISTINCT Bill #)=1"}>} Invoice Amount)

but it says error in expression

Not applicable

Re: Writing syntax

I think you need []

SUM({<Customer ={"=Count(DISTINCT [Bill #])=1"}>} [Invoice Amount])

Not applicable

Re: Writing syntax

Thank you so much it works well..

Not applicable

Re: Writing syntax

Realy Good

Not applicable

Re: Writing syntax

mark as correct the answer to that community get organized

Not applicable

Re: Writing syntax

I have marked it as Helpful. Didn't find any other option. Hope this is what was expected.

Thanks again

Not applicable

Re: Writing syntax

all correct!