Don't suppress null()

[#1]

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

[buzzy996]

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?

[Gysbert_Wassenaar]

Can you post a qlikview document that demonstrates the problem?

[#4]

Hi,

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

[PrashantSangle]

Hi,

What is your expected Count??

Regards

[buzzy996]

try this

[#7]

Hi,

I tried but no success.

[#8]

Then nulls are coming in other columns.

[buzzy996]

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

[#10]

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