topic Re: EXp.Help in QlikView https://community.qlik.com/t5/QlikView/EXp-Help/m-p/330033#M121546 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try using Concat().</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 03 Jul 2012 06:14:38 GMT jagan 2012-07-03T06:14:38Z EXp.Help https://community.qlik.com/t5/QlikView/EXp-Help/m-p/330032#M121545 <HTML><HEAD></HEAD><BODY><P>i m using sum({&lt;month={$(cmonth)}&gt;}visit) to show visit in particular month in bar chart.</P><P>it is showng all visit of month i have category in visits like full,half, quarter.</P><P>when i select full ,half and quarter from selection box i m getting value of that category visit</P><P>1)but i want to display name of category on chart what ever i have select in list box.</P><P>2)is there any way to that i get only category wise visit by adding somthing in above expression.</P><P>3)how to calcutale aggr by visit category using above expression.</P></BODY></HTML> Mon, 02 Jul 2012 19:24:42 GMT https://community.qlik.com/t5/QlikView/EXp-Help/m-p/330032#M121545 2012-07-02T19:24:42Z Re: EXp.Help https://community.qlik.com/t5/QlikView/EXp-Help/m-p/330033#M121546 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try using Concat().</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 03 Jul 2012 06:14:38 GMT https://community.qlik.com/t5/QlikView/EXp-Help/m-p/330033#M121546 jagan 2012-07-03T06:14:38Z Re: EXp.Help https://community.qlik.com/t5/QlikView/EXp-Help/m-p/330034#M121547 <HTML><HEAD></HEAD><BODY><P>use can aggregate like sum({&lt;month={$(cmonth)}&gt;} if(aggr(visit,category),visit)</P><P></P><P>use getfieldselections(Category) to get particular category</P></BODY></HTML> Tue, 03 Jul 2012 08:49:25 GMT https://community.qlik.com/t5/QlikView/EXp-Help/m-p/330034#M121547 sivarajs 2012-07-03T08:49:25Z