Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
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,
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
Hi
I think that should be
if(getcurrentfield(cs)='Date', Group)
since getcurrentfield returns the field name as a string.
HTH
Jonathan
try below
if($(=getcurrentfield(cs))='Date', Group)
Hi Sreeharsha,
PFA.Hope it helps.
Regards
KC
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'
Thank you so much Pradeep, it is working fine
Thank you so much Jyothish, it is working fine