Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider - Maximize your investment, Join this webinar, May 26th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Creator II
Creator II

same dimension twice in Pivot table Qlik sense

Hi,

i need to use the dimension month_name as row and column in pivot table.

 

is  it possible.

 

thanks 🙂

 

8 Replies
tresesco
MVP
MVP

Could you explain the business requirement? I can't really think of any possible case of usefulness. Same dimension in two dimensions doesn't make much sense to me, however, two month fields that are not same but different like one being billing_month and other being delivery_month could be feasible and meaningful.

richard_chilvers
Specialist
Specialist

Hi

 

I have just seen this old discussion. I have a business requirement of this type !

My table records have UK postcode and its latitude & longitude coordinates. Using Lat & Lon, I can calculate the distance between any 2 postcodes.

I would like to select a postcode, then display this postocde (dimension1) and all other postcodes (dimension2) showing the distance between them as a calculated expression.

Any ideas? Thanks

Uday_Pasupuleti
Partner
Partner

You can by adding &'' to the dimension in the column. 

like, Country&''

richard_chilvers
Specialist
Specialist

...is this possible in QlikView ?
Uday_Pasupuleti
Partner
Partner

The concept is same so it should work.
richard_chilvers
Specialist
Specialist

Thank you.
So in my example:
Dimension 1 would be Postcode
Dimension 2 would be Postcode&''

?

When I try this, I get a single row in the chart with identical (selected) values in the 2 dimension columns.
Uday_Pasupuleti
Partner
Partner

I don't have access to QV at present and can't remember the options on top of my head.

Post some images of what you are trying to achieve.
richard_chilvers
Specialist
Specialist

postcodeList.JPG

 

This is a snip of my data where outcode means PostCode. I can calculate the distance between any 2 postcodes based on their lat and lng values.

I want to select one postcode and show a chart of all the other postcodes and their distance from the selected postcode.

 

Thanks