topic Re: Creating pivot or straight table in QlikView

Creating pivot or straight table

farheenayesha — Fri, 21 Feb 2014 13:09:23 GMT

Hi,

I want to know if it is possible to create a chart as below. If it is anyone possible please tell me the procedure to create it.

fkeuroglian — Fri, 21 Feb 2014 13:15:09 GMT

Hi, it is posible you have to create a pivot table using this dimension and expresion

of course you have to use this relation of attributes, if you have it in the model you can do it

if you have the MODALITY and PRODUCT dimensions and the relation between them, you will can

Fernando

Anonymous — Fri, 21 Feb 2014 13:15:39 GMT

Yes its possible to create above chart using pivot table.

Modality and product are two dimensions and values can be displayed

based on expression in expression tab

Please attach sample file.

sujeetsingh — Fri, 21 Feb 2014 13:27:19 GMT

Go for Pivot

farheenayesha — Fri, 21 Feb 2014 13:45:54 GMT

Thanks everyone for your replies.

Actually Modality is not dimension only product is the dimension.

Modality,Qty,AOP and discount are just the headings.

CQ(Current Quarter),PY(Prior Year) etc are sub headings.

I have to calculate Qty, AOP and Discount for CQ,PY,PQ,VPY etc.

I want to know is it possible to calculate and display the values as above figure.

its_anandrjs — Fri, 21 Feb 2014 14:12:56 GMT

Hi,

Use Pivot table option for this and if necessary make some changes in load script or the data model for this.

Thanks & Best Regards,

Anand