topic If Statement in Data range in QlikView

If Statement in Data range

joeychua — Sat, 16 Nov 2024 20:18:13 GMT

I am trying to create an IF statement to call out the data from a date range, for 3 months, 2 months, and 1 month, for a specific type of product.

=MaxString(
{<[Date]={if(">=$(=Date(AddMonths(LasRefresh,-3)) <=$(=Date(AddMonths(LasRefresh,-2)))",'3 Months'

,if(">=$(=Date(AddMonths(LasRefresh,-2)) <=$(=Date(AddMonths(LasRefresh,-1)))",'2 Months')

,if(">=$(=Date(AddMonths(LasRefresh,-1)) <=$(=Date(AddMonths(LasRefresh,-1)))",'1 Month')}
,[Product Type]={'Sale'}
>} [Date] )

Re: If Statement in Data range

miskinmaz — Thu, 08 Aug 2019 05:54:13 GMT

Why don't you just try to add the conditional statement at back end and create one extra field though script.

Re: If Statement in Data range

joeychua — Thu, 08 Aug 2019 08:12:43 GMT

How and what should I add to my expression/script in order to make what i want to display?

Re: If Statement in Data range

Brett_Bleess — Mon, 26 Aug 2019 21:04:38 GMT

Joey, check the following Design Blog Link and note there are some other links at the bottom of that post as well:

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

Hopefully this will help you get things sorted out and feel free to back the URL up to the Qlik-Design-Blog/ level and use the search dialog there to dig further if you wish.

Regards,
Brett