two dimension and one measure

[#1]

Hi,

I need to represent a two dimensional and 1 measured data in Qlik sense which is interrcative as well.

I tried a lot of d3 visualization tools but it doesn't work

Basically one dimension has one group  of the year 2015

and the other dimension has the same groups for 2014 and I want to show how many people in 2014 shifted to the same group of lower group in 2015. I need to show this via a tool

can anyone help me with this

[Anonymous]

Hi ,

Is it like this ?

Try to add    0   as second expression

[#3]

Hi,

this looks good

whats the procedure?

[Gysbert_Wassenaar]

Can you post a small qlikview document with example data?

[#5]

Tiers	2014	2015
zero	12	4
1-35	20	5
36-119	13	11
120+	14	19

[Gysbert_Wassenaar]

Use a bar or line chart with Tiers as dimension and two expressions sum(2014) and sum(2015)

[Anonymous]

1. Create a new bar chart with Year and Tier as dimensions and the expression: Sum(Sales)
2. Edit the chart and add a second expression with just a value of   0:
3. Open the properties and go to the Presentation tab. Deselect the Show  Legend option:
4. Edit the properties of the chart and go to the Axes tab. Set the Secondary Dimension Labels to the / option as shown in the following screenshot:

Note : The two dimensions must be in a strict hierarchy ( i.e Year should be added first in Dimension ....)

[chaper]

As gwassenaar‌ mentioned..

[reddy-s]

HI Sagarika,

You can make use of a bar chart to achieve this.

Both bar chart and line chart allow two dimensions.

Thanks,

Sangram

[reddy-s]

Also, you can make use of drill down dimension to achieve this.