topic Hierarchy? in QlikView https://community.qlik.com/t5/QlikView/Hierarchy/m-p/564947#M1117888 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I have some data in a slightly odd format- please take a look at the attached file with similar data structure. Ideally, I would want to track the stage in film production by year and by quarter of the year, but not sure how to plug this data into Qlikview. I tried a cross table, but it doesn't reflect different years. Could building a hierarchy work?</P><P></P><P>Thanks,</P><P></P><P>Anna </P></BODY></HTML> Mon, 10 Feb 2014 13:34:08 GMT 2014-02-10T13:34:08Z Hierarchy? https://community.qlik.com/t5/QlikView/Hierarchy/m-p/564947#M1117888 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I have some data in a slightly odd format- please take a look at the attached file with similar data structure. Ideally, I would want to track the stage in film production by year and by quarter of the year, but not sure how to plug this data into Qlikview. I tried a cross table, but it doesn't reflect different years. Could building a hierarchy work?</P><P></P><P>Thanks,</P><P></P><P>Anna </P></BODY></HTML> Mon, 10 Feb 2014 13:34:08 GMT https://community.qlik.com/t5/QlikView/Hierarchy/m-p/564947#M1117888 2014-02-10T13:34:08Z Re: Hierarchy? https://community.qlik.com/t5/QlikView/Hierarchy/m-p/564948#M1117889 <HTML><HEAD></HEAD><BODY><P>Hi Anna,</P><P></P><P>You can do it using the Transformation Steps Available in Qlikview Load File Dialog...</P><P></P><P>Please find the attached file in which i have loaded your data.</P><P></P><P>Hope this helps..</P><P></P><P>Regards</P><P>Rahul</P></BODY></HTML> Mon, 10 Feb 2014 13:55:55 GMT https://community.qlik.com/t5/QlikView/Hierarchy/m-p/564948#M1117889 rahulgupta 2014-02-10T13:55:55Z Re: Hierarchy? https://community.qlik.com/t5/QlikView/Hierarchy/m-p/564949#M1117890 <HTML><HEAD></HEAD><BODY><P>it worked, thank you!!</P></BODY></HTML> Mon, 10 Feb 2014 14:37:02 GMT https://community.qlik.com/t5/QlikView/Hierarchy/m-p/564949#M1117890 2014-02-10T14:37:02Z Re: Hierarchy? https://community.qlik.com/t5/QlikView/Hierarchy/m-p/564950#M1117891 <HTML><HEAD></HEAD><BODY><P>@Rahul Gupta, how would a chart reflecting different stages of production be structured? Ideally, I would want to have year(or quarter) and film as dimensions, and to show different stages in expression.</P><P></P><P>Thanks,</P><P></P><P>Anna </P></BODY></HTML> Tue, 11 Feb 2014 11:33:56 GMT https://community.qlik.com/t5/QlikView/Hierarchy/m-p/564950#M1117891 2014-02-11T11:33:56Z Re: Re: Hierarchy? https://community.qlik.com/t5/QlikView/Hierarchy/m-p/564951#M1117892 <HTML><HEAD></HEAD><BODY><P>Hi Anna,</P><P></P><P>In the attached app, we have 4 dimensions namely:</P><P>1. Year</P><P>2. Quarter</P><P>3. Films</P><P>4. Data(i.e the Status of the Film)</P><P></P><P>So, its up to you that How you structure a chart based on the requirement.</P><P></P><P>Attached is the updated app for your reference.</P><P></P><P>Regards</P><P>Rahul</P></BODY></HTML> Tue, 11 Feb 2014 11:59:32 GMT https://community.qlik.com/t5/QlikView/Hierarchy/m-p/564951#M1117892 rahulgupta 2014-02-11T11:59:32Z