Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

akpofureenughwu
Contributor II

Categorizing Measures to Dimensions

Hello everyone,

I need to transform measures into dimension.

Here is my sample data set

YearStateUnsafe ActFatalities
2013Lagos12310
2014Delta25040
2013Delta56756
2014Lagos565

In my visualization, I have successfully create a bar chart showing the safety stats of the states in the available period.

I want to group two measures (Unsafe Act and Fatalities) to become a dimension (CONDITION) that can become a filter...

The user can select various conditions using the CONDITION filter.

Please share your thoughts

Regards

2 Replies
akpofureenughwu
Contributor II

Re: Categorizing Measures to Dimensions

Please find the attached file for clarity,

In the attached. .you will see a bar chart and three filters...

My interest is on the condition filter..... Can we use the condition filter to drill between fatalities and unsafe acts?

Regards

Re: Categorizing Measures to Dimensions

CrossTable(Flag, Value, 2)

LOAD Year,

     State,

     [Unsafe Act],

     Fatalities

FROM

[https://community.qlik.com/thread/296399]

(html, codepage is 1252, embedded labels, table is @1);

Community Browser