topic Re: count expression and limit to 1 in App Development

count expression and limit to 1

joeybird — Tue, 16 Aug 2016 14:42:37 GMT

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

Re: count expression and limit to 1

Gysbert_Wassenaar — Tue, 16 Aug 2016 14:47:02 GMT

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

Re: count expression and limit to 1

joeybird — Tue, 16 Aug 2016 14:50:36 GMT

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

Re: count expression and limit to 1

Gysbert_Wassenaar — Tue, 16 Aug 2016 14:56:29 GMT

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.

Re: count expression and limit to 1

joeybird — Tue, 16 Aug 2016 15:00:48 GMT

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?

Re: count expression and limit to 1

Gysbert_Wassenaar — Tue, 16 Aug 2016 15:09:11 GMT

Re: count expression and limit to 1

joeybird — Tue, 23 Aug 2016 08:46:51 GMT

Thank you,

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