Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Re: count expression and limit to 1
Please post a small qlik sense app that demonstrates the problem.
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
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.
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?
Re: count expression and limit to 1
Thank you,
issue was having two measures on a table chart, the conflicted with each other