Solved: I want to get count(working days) for particular m... - Qlik Community

baarathi · ‎2018-01-16

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)

Anil_Babu_Samineni · ‎2018-01-16

May be try this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2018-01-16

May be try this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

tresesco · ‎2018-01-16

Try '>=' rather than '=>'

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

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