How to hide the dimension in cyclic group in qlikview

[#1]

Can we hide the dimension fron the cyclic group?

For example

Incyclicgroup we have Date, month and Year and if(isshow=1) then need to hide the year dimension from the CG.

Can we do this,

thanks in advance.

[#2]

Hi ,

1.Use this expression for Year in creating group

   = If(isshow=0,Year,Null())

  In Presentation tab of the chart-> In the Null symbol box give a space

2. create 2 groups

   1 with Year (Say Group3 )and 1 without Year (Say Group2)

   Now add calculate dimension like

  = If(isshow=0,[Group3],[Group2])

Hope this will helps you..

[#3]

Either of the one in above

[vikasmahajan]

Hope this helps you.

vikas

[#5]

Is your second choice working?

I tried like this in Pivot table but it is not working.

=if($(isOrdinaryCalendar)=1,[cgInvoiceDate], [cg_FiscalDate])

Regards,

Kabilan K

[#6]

If I am using first choice, I got one empty dimension in cyclic group ryt.?

How to avoid it?

[#7]

Hey I was not tried like that, it was just an idea of myne.

Try like this, I tested and it will work

Create a variable vShow and

add those 2 groups as 2 dimensions and conditional enable expression on each of those like

Dim1 -> Group1(Field1,Field2,Field3) -->Condition : vShow=0

Dim2 -> Group2(Field1,Field2) ---> Condition : vShow=1

[#8]

Problem in pivot table vs CG

See this link u can know my issue.

Regards,

Kabilan K.