Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Want to display latest month data into Blcok chart

Hi,

I want display latest month into block chart and use below expression to achive that fucationality but somehow its not working.

 

Count({<Data_Month = {'>=$(=MonthStart(Min(Data_Month))) <= $(=MonthEnd(Max(Data_Month)))'}>}Employee_Id)

same logic i have applied on Pie chat with SUM then its working perfectly fine.

sum({<Data_Month = {'>=$(=MonthStart(Min(Data_Month))) <= $(=MonthEnd(Max(Data_Month)))'}>}sales)

can you guys please help me on this.

Appreciate your help

2 Replies
edg_baltazar
Contributor

Re: Want to display latest month data into Blcok chart

Could attach your .qvw? , Regards!

Not applicable

Re: Want to display latest month data into Blcok chart

Please find qvw and db file

Community Browser