This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.