topic Re: restrict dimesion values in QlikView https://community.qlik.com/t5/QlikView/restrict-dimesion-values/m-p/758629#M269966 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>=SUM({&lt;CUSTCLASSIFICATIONID={'IAE','IAR','IAT','IAU','IBE','ICH','ICL','ICZ','IDK','IES','IFI','IFR','IHK','IIL','IIS','IIT','IKR','ILU','IMX','IMY','INL','IOM','IPL','IPO','IRC','ITW','IUK','IUS'}</P><P>,INVOICEYear={'$(vMaxYearInvoice)'},INVOICEDATE={"&lt;=$(vMaxDateInvoice)"},INVOICEMonth=,INVOICEDay=,INVOICEMonthYear=&gt;} SALESBALANCEMST)</P></BODY></HTML> Mon, 17 Nov 2014 10:56:25 GMT marcus_malinow 2014-11-17T10:56:25Z restrict dimesion values https://community.qlik.com/t5/QlikView/restrict-dimesion-values/m-p/758628#M269965 <HTML><HEAD></HEAD><BODY><P>this is my expression</P><P></P><P>=SUM({&lt;CUSTCLASSIFICATIONID={IAE,IAR,IAT,IAU,IBE,ICH,ICL,ICZ,IDK,IES,IFI,IFR,IHK,IIL,IIS,IIT,IKR,ILU,IMX,IMY,INL,IOM,IPL,IPO,IRC,ITW,IUK,IUS}&gt;}</P><P>{&lt;INVOICEYear={'$(vMaxYearInvoice)'},INVOICEDATE={'&lt;=$(vMaxDateInvoice)'},INVOICEMonth=,INVOICEDay=,INVOICEMonthYear=&gt;} SALESBALANCEMST)</P><P></P><P>the result is not right i didnt get the restricted value i get the whole sum, how can i combine the Set Analysis expressions? </P><P></P><P>thanx</P></BODY></HTML> Mon, 17 Nov 2014 10:46:22 GMT https://community.qlik.com/t5/QlikView/restrict-dimesion-values/m-p/758628#M269965 2014-11-17T10:46:22Z Re: restrict dimesion values https://community.qlik.com/t5/QlikView/restrict-dimesion-values/m-p/758629#M269966 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>=SUM({&lt;CUSTCLASSIFICATIONID={'IAE','IAR','IAT','IAU','IBE','ICH','ICL','ICZ','IDK','IES','IFI','IFR','IHK','IIL','IIS','IIT','IKR','ILU','IMX','IMY','INL','IOM','IPL','IPO','IRC','ITW','IUK','IUS'}</P><P>,INVOICEYear={'$(vMaxYearInvoice)'},INVOICEDATE={"&lt;=$(vMaxDateInvoice)"},INVOICEMonth=,INVOICEDay=,INVOICEMonthYear=&gt;} SALESBALANCEMST)</P></BODY></HTML> Mon, 17 Nov 2014 10:56:25 GMT https://community.qlik.com/t5/QlikView/restrict-dimesion-values/m-p/758629#M269966 marcus_malinow 2014-11-17T10:56:25Z