Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Varun1
Contributor III
Contributor III

Variable input button is not working on maps

Hey!

I have created two buttons (YTD & MTD) using the variable extension to toggle between the YTD and MTD sales on shown on the map. The expression I have used is as follows: 

=if($(=vYearSales)= 1,
Sum({<Flag={'Sales'},[Dashboard Cust Type]={'AM'},Year=,Month=,Day=,Num_Date={">=$(=num(yearstart(max(Num_Date))))<=$(=max(Num_Date))"}>}Sales),
Sum({<Flag={'Sales'},[Dashboard Cust Type]={'AM'},Year=,Month=,Day=,Num_Date={">=$(=num(monthstart(max(Num_Date))))<=$(=max(Num_Date))"}>}Sales))

The Value given to the YTD button is '1' . The expression works fine when I use it on a table but does not work on the map.

Please let me know if there is a solution to this.

note: the map is inside a container which has three different maps for "Sales", "Budget" and "Ratio" and the same variable is used on all three maps.

 

Thanks & Regards

Labels (4)
0 Replies