topic Re: Expression for flag filter in QlikView

Expression for flag filter

Anonymous — Wed, 28 Jan 2015 14:52:27 GMT

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 — Wed, 28 Jan 2015 15:04:20 GMT

See attached qvw

datanibbler — Wed, 28 Jan 2015 15:06:10 GMT

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 — Wed, 28 Jan 2015 15:06:57 GMT

Hello Gysbert,

i am unable to open the attachment.

Thanks

Bhupal

Anonymous — Thu, 29 Jan 2015 09:46:03 GMT

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