Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Kirsten
New Contributor III

Fixed graph selections on one page

I want to have 6 of the same graphs with different PPG selections. How to do this.

graph 1. PPG1 , PPG2, PPG3

graph 2     PPG4, PPG5, PPG6

But all on one page

See attachment, names hidden due to confidentiality

4 Replies
Highlighted
Ezir
Contributor II

Re: Fixed graph selections on one page

Hello @Kirsten ,

 

I don't know if I understood your need, but I think you could create a calculated dimension.

createNewDimension.png

Dimension1 expression: 

if((PPG='PPG1') or (PPG='PPG2') or (PPG='PPG3'), PPG)

 

 

Dimension2 expression: 

 

if((PPG='PPG4') or (PPG='PPG5') or (PPG='PPG6'), PPG)

 

 

Then uncheck the dimension properties "Include null values"

 

Regards,

 

Ezir

Highlighted
Kirsten
New Contributor III

Re: Fixed graph selections on one page

Hi thanks, it works! But it also messed up my graph a little bit.  I received an additional line at the bottom with text with service area names. I also have an additional bar visible in my graph which are products that can not be matched with a PPG and marked as  - , bars that are not included in the code selection in the dimension.

How to remove the additional line and bar? (see attachment)

Where can I uncheck the dimension properties "Include null values"? Maybe that resolves the bar issue

And how to deal with words with comma’s in the code, only way is to change the word in the masterfile? (see attachment)

Highlighted
Ezir
Contributor II

Re: Fixed graph selections on one page

Hi @Kirsten 

In chart properties, select the calculated dimension and uncheck like below

nullvalues.png

It is necessary to add an additional instance of the quotes used to quote the string

 

 

(PPG='PC''s')

 

 

Regards

 

Ezir

Highlighted
Kirsten
New Contributor III

Re: Fixed graph selections on one page

@Ezir

Is there another place where this code can be used, other than the dimension. Because the graph is being messed up a bit with the dimension :). Maybe as an expression in sort? 

This expression is already in my sort to dictate the order of the service area, now I want to select in the graph only PPG1, PPG2, PPG3 and Service Area 1 (Factory Defect), Service Area 2 (DEFOA) and Service Area 3 (Field replace-War) only

Match([PPG], Dual('Factory Defect',1), Dual('DEFOA',2), Dual('Field Replace-War',3), Dual('Field replace_Contr',4))

How to have all of this integrated in 1 code