Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

I want to get count(working days) for particular month of a year

count({<BILLED={'=>500'}>} Date), This expression show  '-', I'm using qliksense 3.2, I am using this expression Pivot Table, wherein columns I have month-year(May-16)

1 Solution

Accepted Solutions
Highlighted

Re: I want to get count(working days) for particular month of a year

May be try this?

count({<BILLED={">=500"}>} Date)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies
Highlighted

Re: I want to get count(working days) for particular month of a year

May be try this?

count({<BILLED={">=500"}>} Date)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Highlighted
MVP
MVP

Re: I want to get count(working days) for particular month of a year

Try '>=' rather than '=>'

count({<BILLED={'>=500'}>} Date)