topic date field in QlikView

date field

Thu, 03 May 2012 08:37:41 GMT

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.

date field

SunilChauhan — Thu, 03 May 2012 08:42:51 GMT

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

date field

jagannalla — Thu, 03 May 2012 08:44:14 GMT

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

date field

Thu, 03 May 2012 08:45:24 GMT

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

date field

SunilChauhan — Thu, 03 May 2012 08:46:56 GMT

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

date field

Thu, 03 May 2012 08:53:54 GMT

Thanks, hope this will help me.