How to dynamically change the field in set analysis

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

If I want to give user selection on what field to have condition on, say accounting date or payment date, apart from using if statement, is there a way I can may [Accounting Date] as in below statement dynamic so that it can be changed to [Payment date] based on user selection (list box etc)

sum({$<[Accounting Date]={">=$(=vStartDate+0) <=$(=vEndDate+0) "}>}Amount)

Re: How to dynamically change the field in set analysis

sunny_talwar — Wed, 27 Sep 2017 00:01:56 GMT

Create an variable and give user the option to select between Accounting Date and Payment Date and then use that variable within dollar sign expansion

Sum({$<$(vDateType) = {">=$(=vStartDate+0)<=$(=vEndDate+0) "}>}Amount)

topic How to dynamically change the field in set analysis in QlikView

How to dynamically change the field in set analysis

Re: How to dynamically change the field in set analysis