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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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