Сount number by years

[#1]

Hello! I'm new to Qlik and need some help.
I have three attributes: crossroad_id, value and year.

Crossroad_ID	Value	Year
1	100	2015
1	200	2015
1	300	2016
1	400	2016
2	100	2015
2	500	2015
2	300	2015

I need to count number of crossroads by years.
For example, final results should look like: 2 crossroads in 2015, 1 crossroad in 2016.

P.S. I need this to build a Bar Chart.

[marcus_sommer]

Year as dimension and count(distinct Crossroad_ID) as exprression.

- Marcus

[jerryyang756]

You can also do it in script...

Tab:

LOAD

count(DISTINCT Crossroad_ID) as Crossroad_ID, 

Year

FROM (ooxml, embedded labels, table is Sheet1)

Group By

Year;

Reload the data . Take Year as dimension and Only(Crossroad_ID) as expression.