topic Re: If condition in Set analysis in QlikView

If condition in Set analysis

Mon, 14 Jul 2014 06:48:57 GMT

Hi Experts,

As I trying the yesterday sales in a text box, so, I tried like Sum({<DATE1= {'$(=Date(today()-1))'}>} [Sales]), which is working fine.

But I have no transaction of sales on Saturday and Sunday, the same expression shows zero as there is no transactions, so I tried

=If(Today()='Mon',Num(Sum({<DATE1= {'$(=Date(today()-3))'}>} [Sales]),'# ##0'), Num(Sum({<DATE1= {'$(=Date(today()-1))'}>} [Sales]),'# ##0')), but the expression shows no results.

Could you please suggest where I went wrong.

Regards

Re: If condition in Set analysis

Mon, 14 Jul 2014 06:53:16 GMT

if(Weekday(Today())='Mon'

Re: If condition in Set analysis

lironbaram — Mon, 14 Jul 2014 06:54:07 GMT

you need to change it to

=If(weekday(Today())=6,Num(Sum({<DATE1= {'$(=Date(today()-3))'}>} [Sales]),'# ##0'), Num(Sum({<DATE1= {'$(=Date(today()-1))'}>} [Sales]),'# ##0'))

Re: If condition in Set analysis

sujeetsingh — Mon, 14 Jul 2014 06:54:35 GMT

You can use If only to handle all no need to set analysis

Re: If condition in Set analysis

Mon, 14 Jul 2014 07:02:04 GMT

Thanks Experts it works ...!