Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
joeybird
Not applicable

count expression and limit to 1

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: count expression and limit to 1

Re: count expression and limit to 1


talk is cheap, supply exceeds demand
6 Replies
Gysbert_Wassenaar
Not applicable

Re: count expression and limit to 1

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


talk is cheap, supply exceeds demand
joeybird
Not applicable

Re: count expression and limit to 1

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
Not applicable

Re: count expression and limit to 1

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.


talk is cheap, supply exceeds demand
joeybird
Not applicable

Re: count expression and limit to 1

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
Not applicable

Re: count expression and limit to 1

Re: count expression and limit to 1


talk is cheap, supply exceeds demand
joeybird
Not applicable

Re: count expression and limit to 1

Thank you,

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