topic Re: conditional dimension in QlikView

conditional dimension

neha_sri — Fri, 17 Oct 2014 06:08:02 GMT

I have a chart where I have dimension as week num (i.e Week-,Week-1,Week-2,Week-3 ..and so on) I want to remove Week-, so that my dimension should start like (Week-1,Week-2... and so on).How can I do so..

Thanks in anticipation

Re: conditional dimension

tresB — Fri, 17 Oct 2014 06:11:43 GMT

Try like:

If([Week Num]<>'Week-', [Week Num])

And check 'Supress When Value is Null' in dimension tab.

Re: conditional dimension

PrashantSangle — Fri, 17 Oct 2014 06:12:45 GMT

Hi,

Try like

If(not isnull(Subfield(DimensionName,'-',2)),DimensionName)

If(len(trim(Subfield(DimensionName,'-',2)))>0,DimensionName)

Regards

Re: conditional dimension

Fri, 17 Oct 2014 06:13:55 GMT

use set analysis

expression is like this

sum({<week={'*'}-{'week-'}>}dimension) i hope this will help u

Re: conditional dimension

Fri, 17 Oct 2014 06:14:43 GMT

Hi,

Give the dimension as

If(Week num='Week-',null(),week num)

Then Supress Zero values

Regards,

Joshmi

Re: conditional dimension

CELAMBARASAN — Fri, 17 Oct 2014 06:15:20 GMT

You could use dimension

If(WeekNum<>'Week-', WeekNum)

Also you can do with set analysis, Assuming that you have expression as Sum(Sales) then

Sum({$-<WeekNum={'Week-'}>} Sales)

But I wonder how it formed without number. I would recommend to remove that value from the WeekNum Field itself.

Thanks

Celambarasan

Re: conditional dimension

neha_sri — Fri, 17 Oct 2014 06:37:27 GMT

actually I dont want to suppress the 0 value and again i have cyclic drill down in dimension which has one field as Week Num and other dimension as Month