topic Re: What is the difference between these set analysis expressions ? in QlikView

What is the difference between these set analysis expressions ?

Tue, 28 Jun 2016 06:45:33 GMT

Hi all,

I have two text boxes to display the output of following expressions respectively.

=money(Sum({$<[Profit Center]={'216NDD','216OS1'},MonthNumPostDate={$(varPrevCurrMonthNo)},YearNumPostDate={$(varCurrentYear)},WeekNumPostDate={"*"}-{$(varCurrentWeek)}>} [In company code currency POS]))

=money(Sum({$<[Profit Center]={'216NDD','216OS1'},MonthNumPostDate={"<=$(=varPrevCurrMonthNo)"},YearNumPostDate={$(varCurrentYear)}>} [In company code currency POS]))

NOTE:

varPrevCurrMonthNo = if(num(Day(today()))<7,$(varPreviousMonth),$(varCurrentMonth))

varCurrentYear = num(Year(Today()))

varCurrentWeek = num(Week(Today()))

Basically i want to know the difference between MonthNumPostDate={$(varPrevCurrMonthNo)} and

MonthNumPostDate={"<=$(=varPrevCurrMonthNo)"}

Please explain.

-James

Re: What is the difference between these set analysis expressions ?

MK_QSL — Tue, 28 Jun 2016 07:56:22 GMT

MonthNumPostDate={$(varPrevCurrMonthNo)}

The result will be based on MonthNumPostDate=varPrevCurrMonthNo

MonthNumPostDate={"<=$(=varPrevCurrMonthNo)"}

The result will be based on MonthNumPostDate<=varPrevCurrMonthNo

Re: What is the difference between these set analysis expressions ?

Tue, 28 Jun 2016 09:00:11 GMT

But in the second expression it is MonthNumPostDate={"<= but not MonthNumPostDate<={"= know ? Then how come it will take all the values of MonthNumPostDate less than the particular month no. ?

-James

Re: What is the difference between these set analysis expressions ?

MK_QSL — Tue, 28 Jun 2016 09:25:48 GMT

in QV set analysis... <= is written by

= {"<="}

Re: What is the difference between these set analysis expressions ?

Tue, 28 Jun 2016 10:18:32 GMT

Ok, Thanks a lot Man !

-Jamy