Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Null value afer box selection

hi all,

i have a graph like this :

DateN°Employee%Partecipation
201112311045%
201212311254%
201312311365%

%Partecipation is calculated by expression that include the "DATE" information, "employee" is calculated with count expression

I have 3 different selection boxes for DAY - MONTH - YEAR, if i select i.e. 2013 12 31 i want see all rows values for MONTH=12 and DAY = 31

It works for N*employees count(COUNT({$<YEAR=>}EmpID),but for %Partecipation i have null value in 2012 and 2011 rows, maybe because in %Partecipation formula i need Date -(Count({$<YEAR=>}MATRICOLA)

How can i resolve it?

Tyvm

Simone

1 Reply
Not applicable
Author

can you please post sample qvw ?