Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to convert an app in qlik sense from qlik view.
There I encountered with a variable in which '=getcurrentfield(Time)' as expression was present.
But when I tried to make a variable in Qlik sense I couldnt find the getcurrentfield() function in qlik Sense.
What should I do now? Is there any function or expression which can work in the same way as the above mentioned one?
Thanks & regards,
Anas Abbasi !
Didnt get u sangram.
can u plz help me out with this
Hi anjali,
Thanks for making aware of the functions that doesnt work with qliksense.
But here I have extract the field name not the entries in the particular field.
So I guess this wont work in my case. And also I'm using Getcurrentfield on a drill down group 'TIME'.
Thanks & regards
Hi Andrew,
In my case I'm using a drill down group TIME with four different dimensions.
Dim1 > Dim2 > Dim3 > Dim4
Can u plz write it in the same way as u did for the three dimensions.
Thanks a lot.
IF(COUNT([Dim1])<=1 AND COUNT([Dim2])<=1 AND COUNT([Dim3])<=1,'Dim4',
IF(COUNT([Dim1])<=1 AND COUNT([Dim2])<=1,'Dim3',
IF(COUNT([Dim1])<=1,'Dim2','Dim1')))
Thanx a lot.. Let me check , if it works!
Hi Anas,
you can add multiple dimension is the latest Qiksense version and this could be used like a cyclic dimension. Check out the alternate dim/measures property.
Thanks,
Sangram.
This worked for me... I added it as a footnote and it worked great to display the relevant level, etc.
IF(GetSelectedCount([Dim3])>=1,'Dim4',
IF(GetSelectedCount([Dim2])>=1,'Dim3',
IF(GetSelectedCount([Dim1])>=1,'Dim2','Dim1')))