Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ronaldwang
Creator III
Creator III

How to dynamically change the field in set analysis

 

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)

 

1 Solution

Accepted Solutions
sunny_talwar

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)

View solution in original post

1 Reply
sunny_talwar

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)

View solution in original post