topic Re: putting two IF clauses in QlikView

putting two IF clauses

Wed, 25 Nov 2020 16:16:04 GMT

=count(distinct(if(Release = '2017' or Release = '2018',Marketing_Name)))

Hi, above expression is working fine.

but I want the calculation to be done only based on data of past 30 days.

In this case, I want to add a condition where it says if(Date > Max(Date)-30) something like that.

can I include this into the expression?

Thank you!

Re: putting two IF clauses

vishsaggi — Wed, 10 Aug 2016 21:33:07 GMT

Am not sure just Try this ?

=count(DISTINCT {< Release = {'2017','2018'}, Date = { "$(= '>=' & Date(Max(Date)-30, 'DD/MM/YYYY'))"} >} Marketing_Name)

Change the date format if your Date field is different.

Re: putting two IF clauses

sunny_talwar — Wed, 10 Aug 2016 21:53:41 GMT

I would also suggest adding <= in there just because if someone select another Date, the expression won't be restricted to just 30 days.

=Count(DISTINCT {<Release = {'2017','2018'}, Date = {"$(= '>=' & Date(Max(Date)-30, 'DD/MM/YYYY') & '<=' & Date(Max(Date), 'DD/MM/YYYY'))"} >} Marketing_Name)

Re: putting two IF clauses

vishsaggi — Wed, 10 Aug 2016 22:31:58 GMT

Ohh I missed that. Got you. Thanks Sunny.