Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcement: We have made updates to resolve a Page Not Found error. If you still get this error, please let us know in the Community Corner.
joshi_qlikview
Contributor

if i click on 2014 ,it should display 2015,2016 data also

hi Gurus,

if i click on 2014 ,it should display 2015,2016 data also

How to do this,

Thanks in advance

Please find the sample app

4 Replies
Highlighted
Employee
Employee

Re: if i click on 2014 ,it should display 2015,2016 data also

Hi,

Did you test with Set Analisys?

sum({<NewYear=>}[Final Spend])

Only({<NewYear=>}[Capital vs. Expense])

Only({<NewYear=>}[Contract Term Details])

Regards,

MVP & Luminary
MVP & Luminary

Re: if i click on 2014 ,it should display 2015,2016 data also

See attached example.


talk is cheap, supply exceeds demand
joshi_qlikview
Contributor

Re: if i click on 2014 ,it should display 2015,2016 data also

Hi Thanks for your Time,

here the selection dependency on Contract Term,if contract term is 5 Year it should display 2014,2015,2016,2017,2018

Dynamic Display based on selected Contract term

buzzy996
Honored Contributor II

Re: if i click on 2014 ,it should display 2015,2016 data also

just replace in  gwassenaar expression's wherever 2 is there with this  left(contractterm,1)

hopes tht helps.