topic filtering the data in if condition in QlikView

filtering the data in if condition

yogitamehta10 — Mon, 03 Jul 2017 11:50:16 GMT

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.

Re: filtering the data in if condition

ahaahaaha — Mon, 03 Jul 2017 11:53:11 GMT

Hi,

May be like this

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

Re: filtering the data in if condition

BalaBhaskar_Qlik — Mon, 03 Jul 2017 12:45:52 GMT

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

if this is not, can you please check Variable.