Expression for flag filter

[Anonymous]

Hello All,

I am trying to set the filter, but i am not getting exact result what i expect.

Please help me on this.

The scenario is:

sales documen       Item       flag

100                          10           N

100                          10           Y

200                          20           N

300                          40           N

300                          40           Y

400                          50           N

In the report i would like to show the values which i mentioned in the bold and underlined font.

how can i keep the filter expreesion on flag.

Best Regards

Bhupal

[Gysbert_Wassenaar]

See attached qvw

[datanibbler]

Hi,

what is the system behind which records you want to show with your filter?

I guess you'll have to calculate an additional field in your script to base this filter upon - that Y/N field is apparently not sufficient ...

HTH

Best regards,

DataNibbler

[Anonymous]

Hello Gysbert,

i am unable to open the attachment.

Thanks

Bhupal

[Anonymous]

Hi,

System is SAP BI to Qlik View.

QVD generated on the table which is coming from SAP BW.

I would like to consider sales document also along with Flag for filter.

Reagrds

Bhupal