Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

restrict dimesion values

this is my expression

=SUM({<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}>}

{<INVOICEYear={'$(vMaxYearInvoice)'},INVOICEDATE={'<=$(vMaxDateInvoice)'},INVOICEMonth=,INVOICEDay=,INVOICEMonthYear=>} SALESBALANCEMST)

the result is not right i didnt get the restricted value i get the whole sum, how can i combine the Set Analysis expressions?

thanx

1 Solution

Accepted Solutions
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Try this:

=SUM({<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'}

,INVOICEYear={'$(vMaxYearInvoice)'},INVOICEDATE={"<=$(vMaxDateInvoice)"},INVOICEMonth=,INVOICEDay=,INVOICEMonthYear=>} SALESBALANCEMST)

View solution in original post

1 Reply
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Try this:

=SUM({<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'}

,INVOICEYear={'$(vMaxYearInvoice)'},INVOICEDATE={"<=$(vMaxDateInvoice)"},INVOICEMonth=,INVOICEDay=,INVOICEMonthYear=>} SALESBALANCEMST)