Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.