Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor III

?

.

3 Replies
Highlighted
Not applicable

Re: Correct formula

what is there in REF Build field  ? is it a static value?

Highlighted
Valued Contributor

Re: Correct formula

What is the error ?

What is the result and what do you except ?

To have the best effort from the community please upload some screenshot/example image.

Highlighted
Valued Contributor

Re: Correct formula

There is absolute no problem with the formula or syntax. Now question is where are you using this function(in which object), thats matters.

I have created few rows of sample data and tried that function, it gives output without any problem. See the attached Qlikview document.

I have used this function in Chart but it will not work in Text object. As it will give multiple result and text box shows only one value. Please share some more details about it.