Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a set of data, of which the concerned headings are "Nominee", "Date of Nomination" and "Proposition Name".
I have created a line graph that shows the "Date of Nomination" as the dimension and "Count(Nominee)" as a measure.
Does anyone know if it would be possible to add onto the line graph a line that will show the Count(Nominee), but only if Proposition Name is = Technology. The way I envisage this working is by creating a new dimension within QlikSense using an expression but I cannot solve it.
P.S. Ideally the original line won't include Technology as a factor, therefore the solution may be to create two dimensions within QlikSense?
Thanks in advance for your help. If you have any further questions please ask away!
.
Try these two expressions:
Count({<[Proposition Name]={'Technology'}>}Nominee)
Count({<[Proposition Name]-={'Technology'}>}Nominee)
Hi thanks for your response.
Works perfecty!
Just a quick further question: is therer a way to have individual axes for these measures? Purely because one of the lines is massive compared to the other.
Thanks again! Hugely appreciated.
Not in Qlik Sense afaik. It would be a bad idea anyway.