Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Null value afer box selection

can you please post sample qvw ?

Community Browser