Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
md_anasabbasi
Contributor III
Contributor III

Getcurrentfield() equivalent in Qlik sense

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 !

16 Replies
md_anasabbasi
Contributor III
Contributor III
Author

Didnt get u sangram.

can u plz help me out with this

md_anasabbasi
Contributor III
Contributor III
Author

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

md_anasabbasi
Contributor III
Contributor III
Author

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.

Not applicable

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')))

md_anasabbasi
Contributor III
Contributor III
Author

Thanx a lot.. Let me check , if it works!

reddy-s
Master II
Master II

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.

Capture.PNG

Thanks,

Sangram.

wandapec
Partner - Contributor III
Partner - Contributor III

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')))