topic Re: field selection in QlikView

field selection

ssriramin19 — Fri, 28 Aug 2015 09:06:47 GMT

I have two fields LAG_DP and LAG for both the fields the values are 0,1,2,3. The requirement is that ,

when LAG =0 is selected the other field LAG_DP should change to 0 automatically .Similarly if lag 1 is selected lag_dp should change to 1 and so on.

selection will happen only lag and not on lag_dp

how to achieve this

can anyone tell me how to achieve this

Thanks

Sriram

Re: field selection

ssriramin19 — Fri, 28 Aug 2015 09:13:13 GMT

can anyone suggest me how to do the above mentioned changes ?

Re: field selection

tresB — Fri, 28 Aug 2015 09:22:01 GMT

How are these fields associated? If you have scope of changing the assocciation, you can simply create a table like:

Load

LAG_DP,

LAG_DP as LAG;

Load LAG_DP Inline [

LAG_DP

Not so? I guess by now you would realize that you have to explain a bit more about your scenario.

Re: field selection

ssriramin19 — Fri, 28 Aug 2015 09:36:37 GMT

Both lag and lag_dp are determined in a different way in the script. Both are fetched from different sources. Only the values in both the fields lag and lag_dp are same.

These fields if we associate then there could be lot of changes in other parameters in the report.

This is because only lag is selected certain parameters will get computed and will the show the values .lag_dp is used for various other parameters for computation.

Re: field selection

tresB — Fri, 28 Aug 2015 09:40:50 GMT

So they are not associated, right?

Re: field selection

ssriramin19 — Fri, 28 Aug 2015 09:43:08 GMT

They are not associated . They are found from different qvd;s and different sources. Just wanted to know if the values in the field lag is selected will there be effect in lag_dp?

Re: field selection

parthakk — Fri, 28 Aug 2015 09:48:53 GMT

Hi,

U need to create a temp table. u can check the attachment.

Thanks,

Partha Kulkarni

Re: field selection

tresB — Fri, 28 Aug 2015 09:52:19 GMT

Dear Sriram,

When I say association, it means if they are connected in data model. It doesn't matter where they come from. If these fields are not linked, selection in field would not affect in other field. This is why sharing a sample of your qvw helps people here understand your case and help precisely, otherwise, most of the conversations would pass by understanding the problem rather than concentarting on thge solution. Try to share a sample that would actually be equivalent to many to-and-fro replies.

Re: field selection

ssriramin19 — Fri, 28 Aug 2015 10:04:46 GMT

Thanks very much on suggesting the approach , Its working as expected. thanks

Re: field selection

parthakk — Fri, 28 Aug 2015 10:22:51 GMT

You are welcome