topic Re: set analysis in QlikView

set analysis

Tue, 04 Nov 2014 13:32:06 GMT

i facing the problem with set analysis

chart

dimension - ename, empno, hiredate

expr- sum({<MonthNumStd={">=$(=date(max(MonthNumStd)-2))<=$(=max(MonthNumStd))"}>}[SAL S])

according to this expression chart should show the sum of salary of emp, whose joining lie between final two month of max(month) selection.

But It it is showing the sum of current month employee only.

i have attached the file.

2. question ...

i want to show only those employees whose salary = 3000

sum({ (is i need to write again same expression here = 3000),

<MonthNumStd={">=$(=date(max(MonthNumStd)-2))<=$(=max(MonthNumStd))"}>}[SAL S])

MK_QSL — Tue, 04 Nov 2014 13:45:12 GMT

Something wrong in your data model or script....

Select 2013 from YearStd and write a text box expression as SUM([SAL S])...

It's showing 0... Am I Missing something or understanding Something wrong?

Anonymous — Tue, 04 Nov 2014 13:48:45 GMT

You currently have Dec selected as a month and your current set is using the default.

Therefore, you need to add the Month= at the end of your Set Analysis expression:

sum({<MonthNumStd={">=$(=date(max(MonthNumStd)-2))<=$(=max(MonthNumStd))"},Month=>}[SAL S])

I'm working on the salary requirement now.

Tue, 04 Nov 2014 13:52:27 GMT

Actually i have created master calendar based on min ,max date of hiredate of EMP table.

Wrt to year which have no data in emp table , it showing 0.00, which is not a big deal at all ithink.

so why it is showing 0.00

rubenmarin — Tue, 04 Nov 2014 13:53:12 GMT

Exactly = 3000? It could be If(sum({<MonthNumStd={">=$(=max(MonthNumStd)-2)<=$(=max(MonthNumStd))"}, Month>}[SAL S])=3000, 3000)

Also, in set analisys, If you use date() it will return a date from year 1900, think it should be only:

MonthNumStd={">=$(=max(MonthNumStd)-2)<=$(=max(MonthNumStd))"}

It takes 3 months if dec is selected, from 10 to 12, both included.

Tue, 04 Nov 2014 14:32:54 GMT

thanx to all