topic Re: Need help in expression in QlikView

Need help in expression

Mon, 24 Aug 2015 11:52:09 GMT

Hi all,

Please find the attached snap shot.

In my application moevement type 106 have two 105 records.and system is not maintained proper linking.

but still I want remove where ever 105 double entries and 106 single entries.

Please help..........

Thanks & Regards

Surender

Re: Need help in expression

sinanozdemir — Mon, 24 Aug 2015 13:07:11 GMT

Hi Surender,

I am not sure where you want to achieve this, in the front end or in the back end. Here are the solutions for both:

In the front-end, you can achieve this by RowNo() function:

In the back-end, you can use Previous() function:

And your data model will look like this:'

Hope this helps.

Re: Need help in expression

Wed, 26 Aug 2015 10:26:17 GMT

Thanks for your reply.

Actually Script change values are different.

please find the attached snap shot

Fact table like below

RefereceKey, [Material Doc 106],Quantity105,[Material Document1]

HK03 ,5005134977 ,12500, 5005134976

, , 12500,5005180235

Please help

Thanks & regards

Surender

Re: Need help in expression

sasiparupudi1 — Wed, 26 Aug 2015 11:05:59 GMT

please post your application

Re: Need help in expression

sinanozdemir — Wed, 26 Aug 2015 12:30:58 GMT

Hi Surender,

You have a totally different snap shot then what you originally posted. I suggest you either post a sample dataset or an application so that we can understand better your requirements.

Thanks

Re: Need help in expression

kaushiknsolanki — Wed, 26 Aug 2015 12:35:54 GMT

Hi,

Try this.

Load Distinct

RefereceKey, [Material Doc 106],Quantity105

From XYZ;

Regards,

Kaushik Solanki