Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor II

Depending list boxes

Hi,

I'm currently struggling with depending list boxes in my dash board, my plan is to have a user friendly calender based on our business year.

There are three business years

GJ 14/15GJ 15 /16GJ 16 / 17
201409201509201609
201410201510201610
201411201511201612
201412201512201701
201501201601201702
201502201602201703
201503201603201704
201504201604
201505201605
201506201606
201507201607
201508201608

It looks like following

I can select between the business years and I have the month range below, this is working due to this formular in the list box of the month range

=aggr(only({<BusinessYear= P(BusinessYear)>}PostingYearMonth),PostingYearMonth)

If I would only use the

= PostingYearMonth

then I would get all Months from all business years. So the formular is mostly working except when I select one month, then all other months disapears

It would be greate if someone could give me a hint how to change the formular form this listbox to have the other months available, of course base of the selected business year.

I'm grateful for any suggestions.

Many thanks in advance.

Kind regards,

Sven

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Depending list boxes

Hot sure but you can try this.

=aggr(only({1<BusinessYear= P(BusinessYear)>}PostingYearMonth),PostingYearMonth)


Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Depending list boxes

Hot sure but you can try this.

=aggr(only({1<BusinessYear= P(BusinessYear)>}PostingYearMonth),PostingYearMonth)


Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

Highlighted
New Contributor II

Re: Depending list boxes

Indeed, with the 1 it is working like a dream 🙂

Big props to you!

Highlighted
MVP & Luminary
MVP & Luminary

Re: Depending list boxes

Great,

Kindly mark the post as correct.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".