Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

Cross Table

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.

4 Replies
olivierrobin
Specialist III
Specialist III

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

apthansh
Creator
Creator
Author

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

avinashelite

check this thread

multi_header_pivot_import.qvw

sunny_talwar