Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rkspareek1992
Partner - Creator
Partner - Creator

Expression for counting of dates of current Fiscal year, Month, Quarter

Hi,

I want to count no. of days with respect to different dimensions. As I have dimension as segment and month. I want to count total days for of current fiscal year wrt segment and want to count days in that month wrt month.

I want to achieve this from a single variable. Kindly suggest a set analysis from which I can achieve this:

(Desired output is from 1 Apr to 7 June, so total count of days are 68).

Desired output:

Segment_1 Days
68
Agro Commodity68
Aluminium68
Buildestate68
Common68
IT Service68
Lead68
Non-Ferrous68

Month Days
68
Jun7
Apr30
May31
0 Replies