Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

date field

I having different fields such as (Month, quarter , year )in a cyclic group. I need to add one more to this group as day, Which should show the numbers(1to 31) as per the month and year.

5 Replies
SunilChauhan
Champion II
Champion II

go to dimension of chart-> edit group_. select group name (Month,Quarter,Year)-> edit and add day to

this -> apply and ok

hope this helps

Sunil Chauhan
jagannalla
Partner - Specialist III
Partner - Specialist III

First you need to create Day field in your script.

Load Day(DateField) as Day;

Now go to Settings->Doc Properties -> Groups Tab -> Select your groupname in Groups Tab of left side ->Edit -> Select the field which you want to add -> Click on Add button -> OK ->OK

Not applicable
Author

There is no field for day . We need to create it.

SunilChauhan
Champion II
Champion II

if you have date field then

you can create using

Day(date) as day

or you can directly type in group

=Day(date)

hope this helps

Sunil Chauhan
Not applicable
Author

Thanks, hope this will help me.