Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
yogitamehta10
Creator
Creator

filtering the data in if condition

Hi All,

I have this  variable  if( Assessment >$(Vrlifetime),'Yes','No')

I want this to be calculated  criteria  is 10 .

I have doing something like this if( Criteria=10 and  Assessment >$(Vrlifetime),'Yes','No')

any suggestion , on the basis of criteria it will show the result right. so basically for every criteria we have assessment  so want  those assessmentvalues  where  criteria is 10.

2 Replies
ahaahaaha
Partner - Master
Partner - Master

Hi,

May be like this

if( Criteria=10 and  Assessment >$(=Vrlifetime),'Yes','No')

balabhaskarqlik

if( Criteria=10 and  Assessment >'$(=Vrlifetime)','Yes','No')


if this is not, can you please check Variable.