Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to create Q1,Q2, H1 and YTD in one column field in master calendar...

i have to show first and second quarter ,half year and ytd of the same year in one field instead of separate columns of half year and quarter..

5 Replies
PradeepReddy
Specialist II
Specialist II

This is not advisable what u are looking for...

Try something like this...  Qrtr&'-'&HalfYear As Column1

Can you provide the scenario in which you are going to implement this requirement..?

Thanks,

Pradeep

deepakqlikview_123
Specialist
Specialist

it will be better you can use drill down group for exlporing your data.

Thanks

Not applicable
Author

Hi Pradeep,

I want to create a bar chart that have Q1,Q2,H1 and  YTD as dimension .for this i have to create all of these four in one column in backend.And will use this column as dimension in frontend.

like the following image

Untitled.png

Thanks

PradeepReddy
Specialist II
Specialist II

In this scenario, create a "drill down group" as dimension. 

Dimension tab-->Edit Groups-->New--> Add 'Half Year' Column and then "Quarter" Column

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi Pradeep,

Please refer below link ,i hope it help.

http://community.qlik.com/message/623029#623029