topic Re: Don't suppress null() in QlikView

Don't suppress null()

Thu, 30 Apr 2015 11:22:15 GMT

Hi,

I have a straight table with a count expression and it's showing only rows which are meeting criteria and suppressing others.

Expression is - =count({<ReportedMonth={$(vCurrentActMonth)},ReportedYear= {$(vCurrentActYear)}>} distinct floor(CreatedOn))

Now I want all Employee Name, irrespective of when it was created. if it doesn't match the criteria, show 0.

I have tried unchecking suppress null values in both dimension and expression, but nothing worked.

Regards,

Navdeep

Re: Don't suppress null()

buzzy996 — Thu, 30 Apr 2015 11:36:26 GMT

can u try this way,

=If(isnull(count({<ReportedMonth={$(vCurrentActMonth)},ReportedYear= {$(vCurrentActYear)}>} distinct floor(CreatedOn))),null(),count({<ReportedMonth={$(vCurrentActMonth)},ReportedYear= {$(vCurrentActYear)}>} distinct floor(CreatedOn)))

else if possible share ur qvw?

Re: Don't suppress null()

Gysbert_Wassenaar — Thu, 30 Apr 2015 11:41:57 GMT

Can you post a qlikview document that demonstrates the problem?

Re: Don't suppress null()

Thu, 30 Apr 2015 11:49:59 GMT

Hi,

PFA the app. ! I want to show all rows in table irrsepective of year DOJ

Re: Don't suppress null()

PrashantSangle — Thu, 30 Apr 2015 11:56:48 GMT

Hi,

What is your expected Count??

Regards

Re: Don't suppress null()

buzzy996 — Thu, 30 Apr 2015 11:56:56 GMT

try this

Re: Don't suppress null()

Thu, 30 Apr 2015 11:56:58 GMT

Hi,

I tried but no success.

Re: Don't suppress null()

Thu, 30 Apr 2015 11:58:14 GMT

Then nulls are coming in other columns.

Re: Don't suppress null()

buzzy996 — Thu, 30 Apr 2015 12:00:06 GMT

u have to uncheck the check box by selecting the other dimensions.

Re: Don't suppress null()

Thu, 30 Apr 2015 12:00:29 GMT

No problem with count, just that need to show all values and those who don't meet the criteria should be shown as 0

Re: Don't suppress null()

Thu, 30 Apr 2015 12:03:04 GMT

tried, its generating nulls towards the end and if I suppress null values for others then not showing 0 for other years.

Need to show all details for records which are having 0.

Re: Don't suppress null()

buzzy996 — Thu, 30 Apr 2015 12:05:42 GMT

see this

Re: Don't suppress null()

sunny_talwar — Thu, 30 Apr 2015 12:07:10 GMT

Does this look like what you want? (PFA)

Best,

Sunny

Re: Don't suppress null()

Thu, 30 Apr 2015 12:08:08 GMT

Correctly pointed, instead of these "-" we need records for those years.

Re: Don't suppress null()

Gysbert_Wassenaar — Thu, 30 Apr 2015 12:10:07 GMT

See attached qvw. If that's not what you're looking you'll have to explain in more detail what you want as result.

Re: Don't suppress null()

sunny_talwar — Thu, 30 Apr 2015 12:12:39 GMT

Nice one Gysbert Wassenaar‌. I got the same result using another approach (create another expression and hide it from the properties tab)

Best,

Sunny

Re: Don't suppress null()

Thu, 30 Apr 2015 12:15:23 GMT

Hi Sunny, Yes it seems good solution, but I am having this expression as one of the many expression in dynamic reports, thus can't use this, it's breaking my other expression. Please suggest some thing else.

Re: Don't suppress null()

sunny_talwar — Thu, 30 Apr 2015 12:18:06 GMT

Use the method proposed by Gysbert.

Best,

Sunny

Re: Don't suppress null()

buzzy996 — Thu, 30 Apr 2015 12:18:29 GMT

so,u can try Gysbert Wassenaar solution.