Flagging in set analysis

[qlikviewforum]

Instead of flagging it as 1/0 I want to flag it as TRUE/FALSE. Any idea how this could be achieved?

Only problem here is the date range(from and to), else this could have been straight forward. Can anyone help me out on this?

=IF(

  IF(Limit_Days='l_30',[30 days],

  IF(Limit_Days='l_60',[60 days],

  IF(Limit_Days='l_90',[90 days],

  IF(Limit_Days='TBD',[60 days)

       )

   )

   )<1

  ,sum(TOTAL{<Period = {'>$(=date($(VMaxPeriod)-$(VDays))) <=$(=date($(VMaxPeriod))) '}>} 1),

  sum(TOTAL{<Period = {'>$(=date($(VMaxPeriod)-$(VDays))) <=$(=date($(VMaxPeriod))) '}>} 0))

[settu_periasamy · Accepted solution]

Hi,

As per my understanding, you want to show the text 'TRUE' instead of 1, right?

if so, you can try like..

,Replace(sum(TOTAL{<Period = {'>$(=date($(VMaxPeriod)-$(VDays))) <=$(=date($(VMaxPeriod))) '}>} 1),1,'TRUE'),

  Replace(sum(TOTAL{<Period = {'>$(=date($(VMaxPeriod)-$(VDays))) <=$(=date($(VMaxPeriod))) '}>} 0)),0,'FALSE')

[jonathandienst]

For true:

...sum(TOTAL{<Period = {'>$(=date($(VMaxPeriod)-$(VDays))) <=$(=date($(VMaxPeriod))) '}>} true()),...

and false:

...sum(TOTAL{<Period = {'>$(=date($(VMaxPeriod)-$(VDays))) <=$(=date($(VMaxPeriod))) '}>} false()))

[qlikviewforum]

Good idea! it does did the trick but the problem it is showing all the dates except from and to date. Any idea what could be the issue? I am looking into that only. Please let me know if you found the issue.

[qlikviewforum]

It is showing 0 for TRUE and -1 for FALSE. Where as I want to show TRUE/FALSE instead of 0/-1.

[settu_periasamy]

Can you check your Set Expression Properly working or Not?

For Testing Purpose, Add one More expression, Put your Sum Expression.. Like

=sum(TOTAL{<Period = {'>$(=date($(VMaxPeriod)-$(VDays))) <=$(=date($(VMaxPeriod))) '}>} 1)

don't give the label. Then Ok.

check, if the date value (From and To ) is correct or not? Like below screen shot..

[qlikviewforum]

As you mentioned I have added a new expression to check whether the date range is correct or not. It does gives the expected result.

[settu_periasamy]

Is it possible to post the sample?

[qlikviewforum]

I know it would be easy if i can post the example but due to security reasons i cannot attach anything else i would have attached it.

[settu_periasamy]

Ok. Let's give a try..

=Pick(Match(

  IF( IF(Limit_Days='l_30',[30 days],

   IF(Limit_Days='l_60',[60 days],

   IF(Limit_Days='l_90',[90 days],

   IF(Limit_Days='TBD',[60 days))))<1  ,

   sum(TOTAL{<Period = {'>$(=date($(VMaxPeriod)-$(VDays))) <=$(=date($(VMaxPeriod))) '}>} 1),

   sum(TOTAL{<Period = {'>$(=date($(VMaxPeriod)-$(VDays))) <=$(=date($(VMaxPeriod))) '}>} 0)),1,0),'TRUE','FALSE')