topic Re: Flag issue? in QlikView

Flag issue?

Mon, 29 Dec 2014 08:22:59 GMT

Hi All,

I am Having a Flag, in That one i am having only 'Y',

If I am Selecting Flag as 'Y', I am getting the Correct Item No....

I am Having 2000 Items..If I am Selecting Flag as 'Y', I am getting the Correct Item Nos, BUt Items are decreasing upto 1500..(500 Items are Missing)

I need to Show all 2000 Items by selecting the Flag as 'Y' with Correct O/P...

Help me Some one...

Regards,

Heather

Re: Flag issue?

jyothish8807 — Mon, 29 Dec 2014 08:39:03 GMT

Hi Heather,

It sound a little confusing.

If I am Selecting Flag as 'Y', I am getting the Correct Item No....

I am Having 2000 Items..If I am Selecting Flag as 'Y', I am getting the Correct Item Nos, BUt Items are decreasing upto 1500.

Can you please explain a bit more or share your app?

Regards

Re: Flag issue?

tresB — Mon, 29 Dec 2014 08:41:18 GMT

Probably the flag field and the Item field are not from the same table; the tables are linked. Try to generate the flag field in the same table as of field Item.

Re: Flag issue?

jagan — Mon, 29 Dec 2014 08:41:22 GMT

Hi,

May be for Flag Y there are only 1500 records matching, they have not given any false value, you currently flag would be like this

LOAD

If(SomeDimension = 'SomeVale', 'Y') AS Flag

FROM DataSource;

If you change this to

LOAD

If(SomeDimension = 'SomeVale', 'Y', 'N') AS Flag

FROM DataSource;

Now you will get two values in Flag field.

Regards,

jagan.

Re: Flag issue?

its_anandrjs — Mon, 29 Dec 2014 08:43:48 GMT

Can you provide sample file here to look out or what logic you use for the flag creation.

Regards

Anand

Re: Flag issue?

Mon, 29 Dec 2014 08:50:22 GMT

HI KC,

I am having Some Articles, Some of the articles are having Two supplier No.s..

Which Items are having two Supplier No.s they are showing Blank value in the Report, for that Reason I am selecting Flag Condition ='Y' then Correct Supplier No is Coming for the Articles..

In My Report I am Having Some Articles which are not containing any Supplier No., Those articles are missing in the Report If i am selecting the Flag='Y' Condition...

I hope you can understand..

Regards,

Kacy

Re: Flag issue?

MayilVahanan — Mon, 29 Dec 2014 09:18:19 GMT

Hi,

You need to mention 'Y' as flag value for those articles doesn't have supplier no. This resolve your problem

Re: Flag issue?

jyothish8807 — Mon, 29 Dec 2014 10:22:53 GMT

Hi Heather,

Try modifying your flag condition like this:

if(isnull(Supplieno)=-1 or your condition,'Y','N')

Hope it helps.

Regards

Re: Flag issue?

Mon, 29 Dec 2014 11:05:50 GMT

Hi KC,

Can you share some Sample App

Regards,

Kacy

Re: Flag issue?

jyothish8807 — Mon, 29 Dec 2014 11:12:55 GMT

It will be helpful if you share your script used to set the flag.

Regards

Re: Flag issue?

Anonymous — Mon, 29 Dec 2014 11:20:33 GMT

Hope below link will help you to handle flag

http://qlikviewtips.wordpress.com/tag/flags/