Show an expression based on a selection

nayanqlik — Wed, 25 Nov 2020 16:16:04 GMT

I have expressions in a chart table and want it to show based on a selection. I'm just struggling with the syntax in the Conditional Window.

So I have an expression for each of the months. They go up to Dec.

Sum({<Month = {'Jan'}>}TotalAmount)

Sum({<Month = {'Feb'}>}TotalAmount)

......

Sum({<Month = {'Dec'}>}TotalAmount)

I have a List box called Year Spilt. The Values are "1st Half" and "2nd Half" . "1st Half represents months from Jan to Jun and "2nd Half" from Jul to Dec.

So If I select '1st Half", I want only the expressions that contains Month = Jan up to Jun should display. And if I selection "2nd Half", then the expressions containing Month = Jul up to Dec should display. If nothing is selected, then all expressions should display.

How do I do get the correct syntax in the Conditional window.

Thank you

Kind regards

Nayan

Re: Show an expression based on a selection

jpitfield — Thu, 22 Feb 2018 17:53:20 GMT

You could do this

=GetFieldSelections([Year Split]) = '1st Half' or Len(GetFieldSelections([Year Split]))=0

however I would suggest you write a value for full year then use Match(GetFieldSelections([Year Split]),'1st Half' ,'Full Year') & Match(GetFieldSelections([Year Split]),'2nd Half' ,'Full Year') respectively

You could also write the interval values into a calendar to accomplish the same then you could use one expression and the calendar month as a dimension in your chart and filter on the field

HTH Jim

topic Re: Show an expression based on a selection in QlikView

Show an expression based on a selection

Re: Show an expression based on a selection