topic Re: Need Help in QlikView

Need Help

dhanu_today — Fri, 13 Jun 2014 17:44:45 GMT

Hi Everyone,

If the ‘STATUS’ contains 1 or 5 then we have consider SECONDARY ID in the new field say Final-ID in the remaining cases we have to consider the PRIMARY ID.

Based on the derived Final-ID we have to map the ID (from DATA2 from attachment) and get the relevant fields like CODE,AOD,PR_CODE, Identification. Then based on Identification we have get the AREA, AREA CODE.

The same has been attached here with.

Thanks,

Dhanu

Re: Need Help

dhanu_today — Fri, 13 Jun 2014 17:59:06 GMT

Any hint from anyone...

Re: Re: Need Help

venkatg6759 — Fri, 13 Jun 2014 18:08:00 GMT

Check the attachment

Re: Need Help

dhanu_today — Fri, 13 Jun 2014 18:21:41 GMT

Thanks Venkat.It seems working.Onething if in case the final id(which contains secondary id case) not available in the ID(Data2) how can i show Primary Id or blank for that.

I hope you understand.

Thanks,

Dhanu

Re: Need Help

venkatg6759 — Fri, 13 Jun 2014 18:30:47 GMT

Can you pick an ID and explain me .That will help to understand better

Re: Re: Need Help

dhanu_today — Fri, 13 Jun 2014 18:36:55 GMT

Lets say am removing the ID(data2) 40001 then how can i show in this case primary id related data or blank.

Thanks,

Dhanu

Re: Need Help

dhanu_today — Fri, 13 Jun 2014 18:45:35 GMT

The application also not working if am selecting the STATUS 5.

Thanks,

Dhanu

Re: Need Help

venkatg6759 — Fri, 13 Jun 2014 18:53:17 GMT

go to the presentation AOD and uncheck omit rows where Field is NULL

Re: Need Help

dhanu_today — Fri, 13 Jun 2014 19:02:41 GMT

We are getting the data except 1 and 5.Its because of we have consider ID as Secondary ID.

How we have to get the 1 and 5 data also.

Thanks,

Dhanu

Re: Need Help

venkatg6759 — Fri, 13 Jun 2014 19:08:03 GMT

we don't have data for 1 and 5 , since we are joining based on secondary ID

example

if you pick status 1

secondary ID -10001

In Data 2 sheet that ID doesn't exist. so the associations are also blank for that .