topic Re: neeed urgent help in QlikView

neeed urgent help

qlikapple — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 03 Sep 2018 09:45:17 GMT

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 — Mon, 03 Sep 2018 10:05:54 GMT

In the backend model

Ouatges

which shows as yes or no

Yes means with Outage

No means Without Outage

Anonymous — Mon, 03 Sep 2018 10:35:19 GMT

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 — Mon, 03 Sep 2018 10:58:46 GMT

i m getting this error

Anonymous — Mon, 03 Sep 2018 11:07:57 GMT

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

swuehl — Mon, 03 Sep 2018 11:13:34 GMT

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

ahmar811 — Mon, 03 Sep 2018 11:47:34 GMT

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