Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
krish2459
Contributor III
Contributor III

expression issue

Hi ,

 

I'm using the below expresiion but I don't get any values plotted in the chart.

 

=if($(vRepeat _Flag) = 'Yes' and [Repeat Flag] ='Yes' and

sum({<[Movemet Type]={'701','702'},Type={'Rolling 3'}>}total <Material,Plant> Amount) < '-1000',
avg({<Type={'Rolling 3'}>}total <Material,Plant>[Stock Value Main]))

 

where 

 

vRepeat _Flag = if([Repeat Flag]='Yes' and (alt(1-(fabs(sum({<[Movemet Type]={'701','702'},Type={'Rolling 3'}>}total <Material,Plant> Amount))
/
avg({<Type={'Rolling 3'}>}total <Material,Plant>[Stock Value Main])*100),0) < '0.99'),'Yes','No')

 

Please provide any suggestions.

Thanks,

Krish

 

Labels (1)
1 Reply
Dalton_Ruer
Employee
Employee

$(vRepeat _Flag) = 'Yes'????    ---- From your explanation of  how you defined vRepeat_Flag it will always result in some decimal value and never in the word YES.