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

[#2]

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.

[buzzy996]

see this

[sunny_talwar]

Does this look like what you want? (PFA)

Best,

Sunny

[#5]

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

[Gysbert_Wassenaar]

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

[sunny_talwar]

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

Best,

Sunny

[#8]

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.

[sunny_talwar]

Use the method proposed by Gysbert.

Best,

Sunny

[buzzy996]

so,u can try Gysbert Wassenaar  solution.