topic Re: Creating a new Dimension for Multiple Line Graph in App Development

Creating a new Dimension for Multiple Line Graph

Wed, 02 Mar 2016 10:10:41 GMT

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!

Re: Creating a new Dimension for Multiple Line Graph

Gysbert_Wassenaar — Wed, 02 Mar 2016 16:53:13 GMT

Try these two expressions:

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

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

Re: Creating a new Dimension for Multiple Line Graph

Wed, 02 Mar 2016 17:04:01 GMT

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

Gysbert_Wassenaar — Wed, 02 Mar 2016 18:37:09 GMT

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