topic Re: How to Restrict the values in Straight Table in QlikView

How to Restrict the values in Straight Table

Mon, 17 Apr 2017 17:28:19 GMT

Hi All,

I have a Straight table having 7 KPI's. The 7th KPI is derived based on the first 6KPI's.

The o/p of 7th KPI is 'Flag' and Spaces.I want to show only 'Flag ' value in the 7th KPI and ignore the spaces.

Logic for 7th KPI Email Flag Condition:

if([CP Budget]=0,'',

if([ResidentDays Budget]=0,'',

if([Meals Budget]=0,'',if([CP Actual]>=[CP Budget]*1.15,'Flag',

if([CP Actual]<=[CP Budget]*0.85,'Flag',

if([ResidentDays Actual]>=[ResidentDays Budget]*1.15,'Flag',

if([ResidentDays Actual]<=[ResidentDays Budget]*0.85,'Flag',

if([Meals Actual]>=[Meals Budget]*1.15,'Flag',

if([Meals Actual]<=[Meals Budget]*0.85,'Flag','')))))))))

Can any one help on this.

Thanks,

Krishna

Re: How to Restrict the values in Straight Table

Anil_Babu_Samineni — Tue, 18 Apr 2017 02:04:48 GMT

This condition is not working for you?

Re: How to Restrict the values in Straight Table

rahulpawarb — Tue, 18 Apr 2017 04:28:06 GMT

Hello Krishna,

Hope you are keeping well!

As a workaround, you can replace the blank spaces by Null() in the script and create a list box with same expression. Post this make a selection on list box and lock the selection. You can also hide the list box.

Sample modified expression:

if([CP Budget]=0,
   Null(),
   if([ResidentDays Budget]=0,
      Null(),
   if([Meals Budget]=0,
      Null(),
  if([CP Actual]>=[CP Budget]*1.15,
     'Flag',
  if([CP Actual]<=[CP Budget]*0.85,
    'Flag',
    if([ResidentDays Actual]>=[ResidentDays Budget]*1.15,
       'Flag',
       if([ResidentDays Actual]<=[ResidentDays Budget]*0.85,
          'Flag',
          if([Meals Actual]>=[Meals Budget]*1.15,
             'Flag',
             if([Meals Actual]<=[Meals Budget]*0.85,
    'Flag',
    Null()
    )
  )
  )
   )
    )
     )
     )
    )
  )

Hope this will be helpful.

Regards!

Rahul

Re: How to Restrict the values in Straight Table

Tue, 18 Apr 2017 21:59:30 GMT

Thanks,

By using list box it is working.

Re: How to Restrict the values in Straight Table

rahulpawarb — Wed, 19 Apr 2017 02:51:29 GMT

Cheers,

Rahul