Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

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

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

deepaktibhe
Not applicable

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

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

Thanks

Not applicable

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

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
Not applicable

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

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
Not applicable

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

Hi Pradeep,

Please refer below link ,i hope it help.

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