count expression and limit to 1

[joeybird]

Hi

is there a way of count expression on a table chart on a sheet, and then limit that count to 1?

I have a table on a sheet, and my expression on the measure is.. count ( distinct Country = {Denmark} >} sales)...this gives 0 and 1

can this count then be limited to just 1 please and exclude the 0

please help

[Gysbert_Wassenaar]

Please post a small qlik sense app that demonstrates the problem.

[joeybird]

Hi

on a sheet I have a table ..I have added the measure count ( distinct Country = {Denmark} >} sales)...this gives 0 and 1, I just need to do something like

count ( distinct Country = {Denmark} >} sales) = 1, and only show the values = 1

please help

[Gysbert_Wassenaar]

That's amazing. Since that measure contains a syntax error I wouldn't expect it to return anything at all. What you posted also tells me nothing about the context you use that expression in and what data you're using.

[joeybird]

Hi

sorry that is my typo here

measure is

count ( distinct {< Country = {"Denmark"} >} sales)...this give 0 and 1

now I need help please to limit to 1 please?

any ideas please?

[Gysbert_Wassenaar · Accepted solution]

Re: count expression and limit to 1

[joeybird]

Thank you,

issue was having two measures on a table chart, the conflicted with each other