# Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

## Simple set analysis

Hi all

im trying to do a simple set analysis wich restricts the expression the past 6 months. spending a lot of googletime all i came up with is:

however all i get i zero. could somone show me the correct syntax

writing

gets what i want, but im trying to learn the set analysis way of things

ps. using 11 SR 2

best regards

Morten

Tags (3)
1 Solution

Accepted Solutions
MVP

5 Replies
MVP

Not applicable

## Re: Simple set analysis

Thank you so much for the quick respons. It does seem to work, however i seem to be getting different results when using the two expressions:

=count(if(datLatest>addmonths(Today(),-6), FVID))   =2589 (just to show there is a difference)

and

=Count({<datLatest = {">=\$(=Date(AddMonths(Today(),-6)))"} >} FVID)  = 2610

Is there a difference between the two expression?

best regards

Morten

MVP

## Re: Simple set analysis

Yes there is small difference of equal sign in above expression not use and in second use may be rows not fetch in this condition please check.

=count(if(datLatest>addmonths(Today(),-6), FVID))   =2589 (just to show there is a difference)

and

=Count({<datLatest = {">=\$(=Date(AddMonths(Today(),-6)))"} >} FVID)  = 2610

Regards

Anand

Not applicable

## Re: Simple set analysis

thank you for correcting my idiotic mistake

case solved

MVP

You are Welcome

Regards

Anand