topic Re: Variable in Set analysis in QlikView

Variable in Set analysis

Tue, 07 Jul 2015 14:20:39 GMT

Hello, guys!

Need your help.

I need to create an expression in straight table summing values from current month till the end of Dec.

I've got a date field in my script named Vacation_Date with format like 'MMM-YY'.

I've created a variable for current month: vCurrentM=Date(Monthstart(Today()),'MMM-YY')

I try an expression like :Sum({<Vacation_Date={">=$(=vCurrentM)<='Dec-15'"},Vacation_Date=>} Days), but it doesnt work correctly, it sums up all the values of the year.

Any ideas on how to get the desired result?

Sample application is attached.

Thnx!

Re: Variable in Set analysis

sunny_talwar — Tue, 07 Jul 2015 14:29:12 GMT

Try this expression:

Sum({<Vacation_Date={">=$(=vCurrentM)<='Dec-15'"}>} Days)

Re: Variable in Set analysis

MK_QSL — Tue, 07 Jul 2015 14:29:27 GMT

Create one more variable

vYearEnd

Date(YearEnd(Today()),'MMM-YY')

Now use this expression

=Sum({<Vacation_Date = {">=$(vCurrentM)<=$(vYearEnd)"}>}Days)

Re: Variable in Set analysis

Anonymous — Tue, 07 Jul 2015 14:35:06 GMT

I got it by this way:

goto document properties, tab number

select your field Vacation_Date

define it as date to "MMM-YY" (currently it's mixed)

your table wwas showing correct data immediately