topic Re: Dimension in QlikView

Dimension

Fri, 13 Jul 2012 16:55:05 GMT

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.

Re: Dimension

Fri, 13 Jul 2012 17:03:55 GMT

In the expression add the below set analysis

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

Kiran Rokkam.

Re: Dimension

nagaiank — Fri, 13 Jul 2012 17:05:10 GMT

Use calculated dimension defined as

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

and check 'Suppress when value is null'

Re: Dimension

Fri, 13 Jul 2012 17:06:24 GMT

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

CELAMBARASAN — Fri, 13 Jul 2012 17:07:29 GMT

Try this

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

Re: Dimension

Fri, 13 Jul 2012 17:07:59 GMT

That worked perfectly. Thank you!

Re: Dimension

CELAMBARASAN — Fri, 13 Jul 2012 17:09:11 GMT

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

Re: Dimension

Fri, 13 Jul 2012 17:18:16 GMT

Neither of those work.

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