Null value afer box selection

Mon, 10 Feb 2014 10:29:01 GMT

hi all,

i have a graph like this :

Date	N°Employee	%Partecipation
20111231	10	45%
20121231	12	54%
20131231	13	65%

%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

Re: Null value afer box selection

Mon, 10 Feb 2014 13:30:05 GMT

can you please post sample qvw ?

topic Null value afer box selection in QlikView

Null value afer box selection

Re: Null value afer box selection