Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Some help on creating a table...

Hello community,

I don't exactly know how this kind of table is called in English, but I have dug through some posts and looked for similar images like mine but did not find a solution. It must be simple, but as always, you need to know where to click...

I am trying to create this table (from XLS) in QV:

QlikView Table overview.PNG

Sometimes they are referred to as a 'distance' or 'mileage' tables but mine is a little different.

The list of cities on the left is different than the one on top. So I have two dimensions and need a count that will give the number of sales a customer from (eg.) Atlanta buys in Omaha.

I would be very thankfull if someone could throw in a few hints...

Alexander

10 Replies
Digvijay_Singh

This sample may help -

Capture.JPG