Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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

Highlighted
Specialist
Specialist

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

Thanks

Highlighted
Not applicable

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

Highlighted
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

Highlighted
Partner
Partner

Hi Pradeep,

Please refer below link ,i hope it help.

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