Club the dimension into one single filter and perform sorting in qliksense

[Aspiring_Developer]

Hello All,

I have below data :-

Area  , Outlet, Sales

Area1,   Outlet1, 10

Area2,     outlet 2, 20

Area3, Outlet 3, 30

I want to achieve below  in front end:-

Dimension  | Sales

Area1      | 10

Area2 |20

Area3| 30

Outlet 1 |10

Outlet 2 |20

Outlet 2 | 30

The main challenge I am facing here is clubbing the two dimensions into single filter and secondly how can I sort the sales values with respect to Area and outlet in ascending order .

Can anyone please help ? I thought if using value list and create dummy dimension, but it is not static. In future we might get more values like outlet 4, outlet 5, area 4, area 5 and so on.

Thanks

[marcus_sommer]

I wouldn't do it within the UI else within the script, maybe with something like:

t: load Area as Name, 'Area' as Type, Sales resident Rawdata order by Sales;
concatenate(t) load Outlet as Name, 'Outlet' as Type, Sales resident Rawdata order by Sales;

- Marcus