Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Year as dimension and count(distinct Crossroad_ID) as exprression.
- Marcus
You can also do it in script...
Tab:
LOAD
count(DISTINCT Crossroad_ID) as Crossroad_ID,
Year
FROM
Group By
Year;
Reload the data . Take Year as dimension and Only(Crossroad_ID) as expression.