Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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);