problem in set analysis

[arulsettu]

hi

     i used this set analysis

TBAL_CAL_MONTH={$(=max(TBAL_CAL_MONTH)-6)}

its giving last six month value. ex if i select 12th month its showing 6th month value. but if i select 5th month it showing blank values

it should show last year 12th month value.

why its not showing  please clarify anyone?

thanks

[arulsettu]

Hi Steve,

               I used this in set analysis but still getting blank values only. am ding any mistake?

thanks

[arulsettu]

i dont have complete date field

[arulsettu]

Hi peter

          should i use this in set above analysis

[PrashantSangle]

Then Create DateField at script level.

Use MakeDate()

MakeDate(Year,Month)

Regards

[arulsettu]

Hi all

          please look at this

MakeDate(TBAL_CAL_YEAR,TBAL_CAL_MONTH) as datefield

vPrior6=date(AddMonths(datefield,-6),'MMM')

in expression

sum({<datefield={'>=$(vPrior6)'}>}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1)

the result is getting current value only not previous six month value

please check it if you want sample i can do that too

thanks

[arulsettu]

hi max,

          check below what i did if any mistake please tell me

[PrashantSangle]

Hi,

try like

Sum({datefield={">=$(=date(Addmonths(max(datefield),-6)))<=$(=date(max(datefield)))"}}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1)

Check if i missed any brackets and also check date format of datefield and after

date(max(datefield))

Regards

[arulsettu]

here is the sample app

[#10]

Hi Arul,

Can you share your Qlikview file with sample data so that we can try it.

Regards

Priyanka

[arulsettu]

hi max,

               getting same current value only datefield format is M/D/YYYY