Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

Re: Creating a new Dimension for Multiple Line Graph

Try these two expressions:

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

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


talk is cheap, supply exceeds demand
Not applicable

Re: Creating a new Dimension for Multiple Line Graph

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.

Re: Creating a new Dimension for Multiple Line Graph

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


talk is cheap, supply exceeds demand
Community Browser