topic Count Script Returns No Results in QlikView

Count Script Returns No Results

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Why the below code is not showing any result

count({$<$(=[Hours Entered]/[Available hours]) ={'<1'}>} and {<[Month]='April'>}Name)

Re: Count Script Returns No Results

Anonymous — Thu, 17 May 2018 17:44:43 GMT

Hi Sujeeth,

Welcome to the Qlik Community! We happy to have you here.

I have edited the title of this thread from "Hi" to "Count Script Returns No Results" to make it more descriptive. I've also moved it from the Qlik Community Information space to the New to QlikView space, as that is more appropriate for this content.

In the future, please use short but descriptive titles and look for the space that is most fitting for your question, as that will help you get the best responses to your questions.

Thank you!

Qlik Community Team

Re: Count Script Returns No Results

isingh30 — Thu, 17 May 2018 17:50:03 GMT

What exactly is your requirement? Try like this

count({$<[Hours Entered]/[Available hours] ={'<1'}>} , {<Month={'April'}>}Name)

Thanks

Re: Count Script Returns No Results

vishsaggi — Thu, 17 May 2018 18:29:36 GMT

Try like

count({$< Name = {"=([Hours Entered]/[Available hours]) <1" >}, [Month] = {'April'} >}Name)