Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
sakamsureshbabu
Creator
Creator

days creation based on one day in a month

Hi

i have one table like below

  

data target
1/1/201430
2/1/201430
3/1/201430
4/1/201430
5/1/201430
6/1/201430

date format M/D/YYYY

but i want create some another field like

     

data targetdate1target1
1/1/2014301/1/201430/days in month
1/2/201430/days in month
1/3/201430/days in month
1/4/201430/days in month
1/5/201430/days in month
1/6/201430/days in month
1/7/201430/days in month
1/8/201430/days in month
1/9/201430/days in month
1/10/201430/days in month

how can i create like this........

11 Replies
sakamsureshbabu
Creator
Creator
Author

Hi Sasidhar

it is working Thank U......

sasiparupudi1
Master III
Master III

Hi

please close the thread if you got your answer

Thx

Sasi