topic Re: Conditionally hide a dimension in chart in QlikView

Conditionally hide a dimension in chart

Tue, 23 Sep 2014 11:47:50 GMT

Hi All,

Is it possible to hide a dimension conditionally?

My requirement is to hide date dimension conditionally (x axis dimension) .

I'm very new in Qlikview and using QlikView version 11.

Any ideas or examples would be greatly appreciated

Thanks,

Haris

Re: Conditionally hide a dimension in chart

Anonymous — Tue, 23 Sep 2014 11:50:41 GMT

and what are you expecting from the hide dimension in this chart - just a total count?

Re: Conditionally hide a dimension in chart

vinay_hg — Tue, 23 Sep 2014 11:51:43 GMT

yes

insteat of selecting dimension, write in dimension something like this

=if(condition=true,A dimension,Bdimension)

Re: Conditionally hide a dimension in chart

jyothish8807 — Tue, 23 Sep 2014 11:59:57 GMT

Hi Harish,

Do you want to hide date dimension or want to hide the date label?

Regards

Re: Conditionally hide a dimension in chart

Tue, 23 Sep 2014 12:02:48 GMT

each day count but I need to show only the date for every week.

attachment will be making clear

Thanks,

Haris

Re: Conditionally hide a dimension in chart

Tue, 23 Sep 2014 12:03:34 GMT

date label.

Re: Conditionally hide a dimension in chart

Anonymous — Tue, 23 Sep 2014 12:09:31 GMT

you need additional attribute for the date - first date of week WeekStart or WeekEnd functions.

You can create calculated dimension using this functions

Re: Conditionally hide a dimension in chart

Tue, 23 Sep 2014 12:22:55 GMT

Its returning week level aggregated data.

Re: Conditionally hide a dimension in chart

vinay_hg — Tue, 23 Sep 2014 12:37:17 GMT

use cyclic or drilldown dimesion.

Re: Conditionally hide a dimension in chart

Tue, 23 Sep 2014 13:23:35 GMT

its direct date object . not created any cyclic or drilldown groups

Re: Conditionally hide a dimension in chart

Tue, 23 Sep 2014 13:28:53 GMT

I am also facing same kind of issues.anyone help is appreciated

Re: Conditionally hide a dimension in chart

jyothish8807 — Tue, 23 Sep 2014 15:35:30 GMT

Hi,

Try in script.

ceil(num(date(datefield))/7) as Week

take week as dimension.Hope it works.

Regards

Jyothish KC

Re: Conditionally hide a dimension in chart

MarcoWedel — Tue, 23 Sep 2014 16:00:52 GMT

Axis tab.

Switch to continuous Dimension axis step width 7.

Re: Conditionally hide a dimension in chart

Wed, 24 Sep 2014 10:06:53 GMT

Input data should be in date format and then in AXIS tab change to Continuous and static step to 7 and in Number tab you will get continuos axis there you need to change the datatype to Date

Thanks,

Indira