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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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

Labels (1)
1 Reply
Not applicable
Author

can you please post sample qvw ?