Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating a new Dimension for Multiple Line Graph

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!

.

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try these two expressions:

Count({<[Proposition Name]={'Technology'}>}Nominee)

Count({<[Proposition Name]-={'Technology'}>}Nominee)


talk is cheap, supply exceeds demand
Not applicable
Author

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.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Not in Qlik Sense afaik. It would be a bad idea anyway.


talk is cheap, supply exceeds demand