Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sandeepprasad_j
Contributor

About giving the before and after 3:00Am and before 6:00am expressions

Hi all,

    

     I have a table where i had to find the work done between 3 am and 6 am and also need to find out the after 6am .so i am a new learner .. can anyone help me out for doing this .. i need some expressions how to calculate ..

I am pasting a scree shot ... time period.JPG

1 Reply
sandeepprasad_j
Contributor

Re: About giving the before and after 3:00Am and before 6:00am expressions

This is d code which i had used for doing the same as per the image .

giving u a single expression for before 3 ...

count(if([DIAD AVAILABLE]<='3:00AM',1))

Community Browser