If condition in Set Analysis

joeychua — Sat, 16 Nov 2024 20:16:43 GMT

I intend to create a table to display a 'Message' in an IF condition. The IF condition is between 9-12 months of data and a specific Status, while the other IF condition is 3-6 months of data

This is my expression,

=Maxstring(

if(

{<[Proposal Approval Date]={">=$(=Date(AddMonths(LasRefresh,-12))) <=$(=Date(AddMonths(LasRefresh,-9)))"}

,[Status]= 'In Progress')

{<[Proposal Approval Date]={">=$(=Date(AddMonths(LasRefresh,-6)))""<=$(=Date(AddMonths(LasRefresh,-3)))"}

,[Status] = 'Completed'))

>}'Expired')

Re: If condition in Set Analysis

Arthur_Fong — Fri, 16 Aug 2019 05:57:37 GMT

What is the issue you facing?

topic Re: If condition in Set Analysis in QlikView

If condition in Set Analysis

Re: If condition in Set Analysis