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.
susovan_g
Valued Contributor

Date Count in Qlikview

Through this expression '=Count({<@_Date={">=$(vstdt1)<=$(vToday)"},@_Date=,@_FinQuarter=,@_FinFullYear=>}DISTINCT %_WEEKEND_DATE)'.

When Select the date at first time then the date count will be show but second time onwards its not working. This date count is static its not change.

1 Solution

Accepted Solutions

Re: Date Count in Qlikview

‌May be removw the second @_Date

=Count({<@_Date={">=$(vstdt1)<=$(vToday)"},@_FinQuarter=,@_FinFullYear=>}DISTINCT %_WEEKEND_DATE)

5 Replies

Re: Date Count in Qlikview

‌May be removw the second @_Date

=Count({<@_Date={">=$(vstdt1)<=$(vToday)"},@_FinQuarter=,@_FinFullYear=>}DISTINCT %_WEEKEND_DATE)

susovan_g
Valued Contributor

Re: Date Count in Qlikview

Thanks fro this valuable suggestion.

Re: Date Count in Qlikview

‌Did it work?

susovan_g
Valued Contributor

Re: Date Count in Qlikview

Yes, Its working.

Re: Date Count in Qlikview

Awesome

Community Browser