Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
ziabobaz
Contributor 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

Tags (1)
1 Solution

Accepted Solutions

Re: Create Dimension from two or more Measures

Dimension

ValueList('SessionCartView', 'SessionCatalogView')

Expression

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

Expression1, Expression2)

View solution in original post

3 Replies

Re: Create Dimension from two or more Measures

May be use ValueList function?

Re: Create Dimension from two or more Measures

Dimension

ValueList('SessionCartView', 'SessionCatalogView')

Expression

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

Expression1, Expression2)

View solution in original post

ziabobaz
Contributor III

Re: Create Dimension from two or more Measures

you are right, thank you