Categorizing Measures to Dimensions

[akpofureenughwu]

Hello everyone,

I need to transform measures into dimension.

Here is my sample data set

Year	State	Unsafe Act	Fatalities
2013	Lagos	123	10
2014	Delta	250	40
2013	Delta	567	56
2014	Lagos	56	5

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

[akpofureenughwu]

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

[MK_QSL]

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);