Skip to main content

New to Qlik Sense

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
LhZagora
Contributor
Contributor

Formula probleme

Can any tell me why this formula doesnt work 

LhZagora_0-1587904943007.png

this formula represent PS new Vs , what im trying to do is that i have a table with : those variable :

LhZagora_1-1587905184918.png

the point its to to calculate new Ps when a i have a new vs as input. 

Can someone help please.

I have calculted the closest number via this formula : FirstSortedValue(DISTINCT Vs, fAbs(Vs-NewVs))

 

4 Replies
bhaskar_sm
Partner - Creator III
Partner - Creator III

Hi,

Can you please tell us  Closest Number is a value , field name or variable name?

if its a value you then need to put this in single quotes i.e 'Closest Number '. or

if its a field name then you need to put this in square brackets or in double-quotes i.e "Closest Number" or [Closest Number]

if its a variable name then you need to use $ sign i.e $(Closest Number)

Thanks,

BK

 

LhZagora
Contributor
Contributor
Author

Closeset number it a variable name that eqauls to this formula  FirstSortedValue(DISTINCT Vs, fAbs(Vs-NewVs))

LhZagora_0-1587933561736.png
LhZagora
Contributor
Contributor
Author

I have updated the formula of Ps New Vs but its not working again as you can see below

Capture.PNGCapture2.PNG

bhaskar_sm
Partner - Creator III
Partner - Creator III

can you share the test app?