Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
neetu_singh
Partner - Creator III
Partner - Creator III

Need Help for PREVIOUS SELECTION

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.

Labels (1)
16 Replies
neetu_singh
Partner - Creator III
Partner - Creator III
Author

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.

tresB
Champion III
Champion III

Sorry, uploaded the right qvw. Please check above.

neetu_singh
Partner - Creator III
Partner - Creator III
Author

Not working in my application.

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

Thanks for all your help.

!

tresB
Champion III
Champion III

Can't open it. Try to re upload.

neetu_singh
Partner - Creator III
Partner - Creator III
Author

please chk

tresB
Champion III
Champion III

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

neetu_singh
Partner - Creator III
Partner - Creator III
Author

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.