Need to show three dimensions in a single cyclic group

[#1]

Hello Everyone,

I need to change the dimension by using cyclic group, that we can do,

But,I have below scenario,

i need to show Date, Week and Month as dimensions

i can create the cyclic group for these three dimensions.

But if i select Date there are another two dimensions should show, like group and SM, these two dimensions should show when date is selected only, when month ad week is selected these dimensions should not show

Is this possible to do like this in the Qlikview?

Thanks in advance

[julian_rodriguez · Accepted solution]

Hello,

It's possible.

If your Cyclic group is named for example "CG_Time", you can enable the Conditional setting for another the dimensions like this:

GetCurrentField(CG_Time) = Date

This function will enable the dimension only when the Date field is enabled on the Cyclic group "CG_Time"

Regards,

[#3]

Hello Julian,

Thanks for the response,

I tried it, I created cyclic group with date, month and week_no, i named cyclic group is cs,

when i write condition in the enable condition text box.

1) cs is showing as error,

2) still i used cs like if(getcurrentfield(cs)=Date, Group) , unfortunately it is not working

any other idea, Please let me know

Regards,

Sreeharsha V

[jonathandienst]

Hi

I think that should be

     if(getcurrentfield(cs)='Date', Group)

since getcurrentfield returns the field name as a string.

HTH

Jonathan

[SunilChauhan]

try below

if($(=getcurrentfield(cs))='Date', Group)

[jyothish8807]

Hi Sreeharsha,

PFA.Hope it helps.

Regards

KC

[PradeepReddy]

If I understand correctly, on selection of Date from Cyclic Group then only the other dimensions 'Group' and 'SIM' need to display.

Try something like this...

Take 3 dimensions

1) Cyclic Group (CS)

2) Group

3) SIM

Write an  expression for conditional enabling for the dimension Group & SIM as

getcurrentfield(CS)='Date'

[#8]

Thank you so much Pradeep, it is working fine

[#9]

Thank you so much Jyothish, it is working fine