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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.