topic Re: Cross Table in QlikView

Cross Table

apthansh — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I have attached file but this is not in a friendly format.I want to do cross table but not sure how to group 3 different elements.Any help is appreiated.

Basically I want the below fields

Location,

CC,

#OFSpots,

Contract,

MethodofPayment,(this should have all values(types & values(now its just X as place holder)) from column E to K)

SourceofRevenue,(this should have all values(types & values(now its just X as place holder)) from column L to R)

Expense Payed by client (this should have all values (types & values(now its just X as place holder)) from column S to W)

Thanks much,

Ansh.

Re: Cross Table

olivierrobin — Wed, 21 Mar 2018 10:51:21 GMT

hello

for me, you have to put in dimensions

location,cc,#of spots, contract

horizontal dimensions method / Source/expenses

but i dépends on what data you have

Re: Cross Table

apthansh — Wed, 21 Mar 2018 11:47:22 GMT

sunny‌t stalwar1‌ any thoughts please...you are my blessing always

Re: Cross Table

avinashelite — Wed, 21 Mar 2018 11:51:20 GMT

check this thread

multi_header_pivot_import.qvw

Re: Cross Table

sunny_talwar — Wed, 21 Mar 2018 11:51:43 GMT

May be look here

multi_header_pivot_import.qvw