Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Transpose of Dimension and Metrics

Hi,

I have a requirement wherein the users must be given the option to do a transponse between the dimensions and metrics based  on their need.

I do understand this could be done as  a one time set up using pivot table and dragging the column as row.

But what if the user wants to leverage this option and make the transpose based upon his/her need.

Could anyone please let me know how it could be done.

3 Replies
sriharsha96
Creator II
Creator II

Hi

I Have an idea see if it is helpfull  even I had a smiler kind of problem once

create different pivot tables from the same original pivot table if you need to transpose 3 dimensions then create 3 pivot charts and add a button and allow them to select respectively and hide the pivot tables which are all not required 

for example:

a b c d sum are the dimension

now you need to create 4 tables of pivot and hide them respectively if you want 'a' as transposed dimension you need to hide others

respectively for 'b' then respectively for 'c'


try it as temporary fix


Regards

Harsha


ashfaq_haseeb

Hi,

If end user is allowed to move objects then he can transpose the way he like.

Regards

ASHFAQ

thomaswrieck
Partner
Partner

Hi,

Create two tables. One for the dimensions and one for the metrics


Screen1.png


See e.g. content for the dimensions …


Screen2.png


Now add all the possible dimensions in one chart and add a Condition for each dimension as shown in the screenshots.


Screen3.png

Similar config for the metrics …


Screen4.png


Now provide listboxes for dimensions and metrics to be choosablefrom the gui ...


Screen5.png



Regards