Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Dimension

I have a bar chart. My dimension is 'Usergroup' but I want the bar chart to only display all 'Usergroup' not equal to MGR or VP.

Any help would be great.

1 Solution

Accepted Solutions
nagaiank
Valued Contributor III

Re: Dimension

Use calculated dimension defined as

If(Match(Usergroup,'MGR','VP')=0,Usergroup,Null())

and check 'Suppress when value is null'

7 Replies
Not applicable

Re: Dimension

In the expression add the below set analysis

{<Usergroup-={'MGR','VP'}>}

Kiran Rokkam.

nagaiank
Valued Contributor III

Re: Dimension

Use calculated dimension defined as

If(Match(Usergroup,'MGR','VP')=0,Usergroup,Null())

and check 'Suppress when value is null'

Not applicable

Re: Dimension

I already have two expressions. One for a count and one for a sum of hours.

 

=

count({<Date = {">=$(=weekstart(today(),0))<=$(=weekend(today(),0))"},
Month=, Day=, Year=, Week=, Quarter=>} distinct(TechID))*40

 

=

sum({<Date = {">=$(=weekstart(today(),0))<=$(=weekend(today(),0))"}>} TimeReportedActual)

Would that have to integrate with these or would it be by itself as another expression?

Re: Dimension

Try this

IF(Not Match(Usergroup, 'MGR', 'VP'), Usergroup)

Not applicable

Re: Dimension

That worked perfectly. Thank you!

Re: Dimension

Then expressions should be

=

count({<Usergroup -={'MGR', 'VP'}, Date = {">=$(=weekstart(today(),0))<=$(=weekend(today(),0))"},
Month=, Day=, Year=, Week=, Quarter=>} distinct(TechID))*40

=

sum({<Usergroup -={'MGR', 'VP'}, Date = {">=$(=weekstart(today(),0))<=$(=weekend(today(),0))"}>}TimeReportedActual)

Set analysis is faster than calculated dimensions

Not applicable

Re: Dimension

Neither of those work.

If set analysis is better I would prefer to do it that way.

Community Browser