Discussion board where members can get started with Qlik Sense.
Hello! I'm new to Qlik and need some help.I have three attributes: crossroad_id, value and year.
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.
You can also do it in script...
count(DISTINCT Crossroad_ID) as Crossroad_ID,
FROM (ooxml, embedded labels, table is Sheet1)
Reload the data . Take Year as dimension and Only(Crossroad_ID) as expression.