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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ziabobaz
Creator III
Creator III

Create Dimension from two or more Measures

Hi, i have the following data structure

SourceSessionsCatalogViewSessionsCartView
facebook1012
instagram54

I want to create Dimension, say [SessionViews], which would include SessionsCartView and SessionsCatalogView

Why?


I need to build a pie chart, where i can only use one dimension and one measure.


Unfortunately, I can't change the structure of the data.

Is that doable?

Thank you

1 Solution

Accepted Solutions
sunny_talwar

Dimension

ValueList('SessionCartView', 'SessionCatalogView')

Expression

Pick(Match(ValueList('SessionCartView', 'SessionCatalogView'), 'SessionCartView', 'SessionCatalogView'),

Expression1, Expression2)

View solution in original post

3 Replies
sunny_talwar

May be use ValueList function?

sunny_talwar

Dimension

ValueList('SessionCartView', 'SessionCatalogView')

Expression

Pick(Match(ValueList('SessionCartView', 'SessionCatalogView'), 'SessionCartView', 'SessionCatalogView'),

Expression1, Expression2)

ziabobaz
Creator III
Creator III
Author

you are right, thank you