topic Re: prob with pivot in QlikView

prob with pivot

Tue, 03 Mar 2015 14:49:22 GMT

Hi all,

i have a prob wit two tables in a Pivot Table:

with the first table i create a Pivot table with differnet dimensions. all is fine

the last Dimension is the coscenter

like this

first dim| secondim| costcenter 1745

1746

1747

in the first table trhe last value ist for the costcenter.

the second table contains values for only costcenter 1747

how can i bring These values in my Pivot. second Problem are the datefields.

first table i have year field and month field

second table only a det filed

i have to select by the periods of a year

last Problem is a different financial year.

can someone help me?

Re: prob with pivot

giakoum — Tue, 03 Mar 2015 14:51:10 GMT

showing only 1747 must have to do with your data model. Could you post a sample app?

Re: prob with pivot

chrismarlow — Tue, 03 Mar 2015 15:02:03 GMT

I think you need to concatenate your data into 1 fact table, fixing odd fields as you go (so creating a full date where you only have month/year assuming either first or last day of the month). Difficult to say anything further without a sample app as Ioannis suggests.