topic Re: Need Help for PREVIOUS SELECTION in QlikView

Need Help for PREVIOUS SELECTION

neetu_singh — Fri, 16 Oct 2015 09:45:36 GMT

Hi All,

As we all know that if we need a data for "previous selection". We can achieve the same by using - sum({$1} Sales).

But in my document it is not working, am not able to get the sales for previous selection.

Can you please help me by some other way using variable or something else if $1 is not working.

Thanks in Advance.

Re: Need Help for PREVIOUS SELECTION

tresB — Fri, 16 Oct 2015 09:53:26 GMT

Not sure if there is any solution with macro for that or not. However, before exploring for that, I would prefer to investigate why $1 would not work. Is it a conscious call, or you are fade up with not finding the reason? If so, may be we too could give a try with your sample qvw that demonstrates the issue.

Re: Need Help for PREVIOUS SELECTION

jsingh71 — Fri, 16 Oct 2015 10:02:38 GMT

Can you upload sample application so its easy to investigate why $1 is not working.

Re: Need Help for PREVIOUS SELECTION

neetu_singh — Thu, 05 Nov 2015 07:14:57 GMT

Thanks for your reply.

Actually in my application ${1} is not working because of trigger as am using some trigger on a field. And we can not avoid those triggers.

Is there any other alternative to achieve the "Previous Selection".

Please find the sample file attached herewith.

Re: Need Help for PREVIOUS SELECTION

tresB — Thu, 05 Nov 2015 07:24:13 GMT

So it is actually taking one step back/forward because of the trigger or so. You could simply use $2 in that case.

Re: Need Help for PREVIOUS SELECTION

neetu_singh — Thu, 05 Nov 2015 07:40:42 GMT

Hi Tresesco,

I tried the same, but no luck

Re: Need Help for PREVIOUS SELECTION

tresB — Thu, 05 Nov 2015 07:45:52 GMT

Working at my end (with your sample qvw).

Re: Need Help for PREVIOUS SELECTION

Mark_Little — Thu, 05 Nov 2015 08:55:31 GMT

HI,

Just having a play and it seem to work if you apply only( {$1} END_YEAR ) to a variable on your trigger.

See attached

Mark

Re: Need Help for PREVIOUS SELECTION

neetu_singh — Thu, 05 Nov 2015 09:17:17 GMT

In my application, there are many triggers not only one that is the reason it's not working.

Is there any other way to fix previous selection issue like variable or island table.

Re: Need Help for PREVIOUS SELECTION

tresB — Thu, 05 Nov 2015 09:38:54 GMT

You can try setting a trigger with the same field selection like in attached sample. Note: put this set variable action on top.

Re: Need Help for PREVIOUS SELECTION

neetu_singh — Thu, 05 Nov 2015 09:52:22 GMT

Sorry tresesco, In your attached application am not able to see any previous selection & set variable thing.

Can you please help to elaborate the same.

Re: Need Help for PREVIOUS SELECTION

tresB — Thu, 05 Nov 2015 09:57:06 GMT

Sorry, uploaded the right qvw. Please check above.

Re: Need Help for PREVIOUS SELECTION

neetu_singh — Thu, 05 Nov 2015 10:36:18 GMT

Not working in my application.

Can you please check in my application, need the same in the attached file.

Thanks for all your help.

Re: Need Help for PREVIOUS SELECTION

tresB — Thu, 05 Nov 2015 10:49:02 GMT

Can't open it. Try to re upload.

Re: Need Help for PREVIOUS SELECTION

neetu_singh — Thu, 05 Nov 2015 11:09:53 GMT

please chk

Re: Need Help for PREVIOUS SELECTION

tresB — Thu, 05 Nov 2015 12:33:51 GMT

So many triggers ! that too interdependent. Not a good approach i tempt to say. Once, you select in your year field, there are many selections(by trigger) happening inside. And that is what making it tough to trace the previous selection. After you select a value from year field, press Back (selection) and see only after nine back presses one Back works. Hence, for this app, if you use $9, it would work. but this might change if you add more triggers. So, try pressing Back and get the count when the actual works; use that number with $.

Hope this helps

Re: Need Help for PREVIOUS SELECTION

neetu_singh — Thu, 05 Nov 2015 12:54:37 GMT

Thanks Tresesco for your help.

I know so many triggers are not a good approach but this one is already a designed application & we can not afford redesigning for this app as this one is a very huge amount tabs in this nd all are interdependent that's why we need to figure out solution into the existing one.

But must say you are awesome

Thanks for all your help.