Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Vasiliy_Beshentsev
Creator III
Creator III

FieldElemNo ?

Hello.

Can't find any information about this function in help.

Any idea?

2017-05-31 14_58_44-Qlik Sense Desktop.png

2017-05-31 15_03_26-Qlik Sense Desktop.png

9 Replies
ahaahaaha
Partner
Partner

Hi Vasiliy,

The function FieldElemNo() is present in environment QlikView, but it is not in Qlik Sence, and all the values it will result in -3. Maybe this is an out-of-date function, inferred from circulation?

Regards,

Andrey

JaMajka1
Partner
Partner

I tried in on my data data (string and numeric with different lengths) and the result is still -3.

ahaahaaha
Partner
Partner

Qlik Sence Desktop does not have this function1.jpg

JaMajka1
Partner
Partner

In Qlik Sense desktop you can find and use it in expression editor in frontend.

Vasiliy_Beshentsev
Creator III
Creator III
Author

Кароче я так понял, что это ненужная в сенсе функция, которую разрабы забыли убрать со времен вью.

ahaahaaha
Partner
Partner

Let's wait, maybe more experienced colleagues will tell us the truth

ahaahaaha
Partner
Partner

In the picture above, it seems like there is no this function in the hint list. And in the code on it QS "swears"

JaMajka1
Partner
Partner

Probably this is it. It also does not exists in qlik.help.com.

ludwikkaminski
Contributor II
Contributor II

Cześć,

I don't know exactly how FieldElemNo works, but I found sollution for this to use: FieldIndex('MapaCRM',MapaCRM). MapaCRM is my field name. This show number of field element. 

Now we can use sth like this: Pick(FieldIndex('MapaCRM',MapaCRM),exp1,exp2,...). 

 

BR,

Ludwik