neeed urgent help

[qlikapple]

HI

i have filed dirctly coming from the datamodel

Outage Reference

In the front end

i am writing the expresion as

=num(Count(distinct  if(isnull([Outage Reference]),incidentnum)),'#####,######')   as Witht Outage

and one more expression as

=num(Count(distinct  if(not isnull([Outage Reference]),incident_ref_num)),'#####,######')  as WithOut  Outage

I need to cretae a flag in the model  as Withoutage as Yes and Without as NO  so that i can remove the Graph and make it as filter

Outage

Yes   NO

How can i do

[Anonymous]

in the model you Need to enhance the table

if(isnull([Outage Reference]),incidentnum)),'YES','NO')   as With_Outage

if(not isnull([Outage Reference]),incident_ref_num)),'YES','NO'')  as WithOut  Outage

[qlikapple]

In the backend  model

Ouatges

which shows as yes or no

Yes means with Outage

No means Without Outage

[Anonymous]

in the backend your outage reference shows two fields incidentnum and incident_ref_num

if they are identical you only need

if(isnull([Outage Reference]),incidentnum)),'YES','NO')   as FlagOutage

In the backend you select yes or no. no checkboxes but a listbox

[qlikapple]

hi

i m getting this error

[Anonymous]

you Need to delete the right bracket (shown in red)

[swuehl]

Also, it seems that you have two field definitions for With_Outage

[ahmar811]

Create a Field from back end like below

if(isnull([Outage Reference]),'Yes',

if(not isnull([Outage Reference]),'No')) as Flag,

I hope this will help you.

Regards

Ahmar