topic Re: How to restrict values in a dimension in QlikView

How to restrict values in a dimension

paul_ripley — Fri, 15 Nov 2024 23:50:31 GMT

Hello

I have table of portfolio values. I only want to show the values that begin with IC (some begin with EX)

I'm not sure if I do this as a calculated dimension or within the expression.

I tried the below in the expresson so I suspect mayabe i need to do this as a calculated dimension but not sure how

sum({$ <period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"}, groupcoa ={4006}, portfolio = {'IC*'} >} cur_amount )

Many thanks

Paul

Re: How to restrict values in a dimension

ramchalla — Thu, 08 Oct 2020 16:08:28 GMT

Hi @paul_ripley ,

it is good to create a new field in script editor and use that field in the table. please try replacing single quotes with double quotes in the set expression for portfolio. try using the below expression.

sum({$ <period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"}, groupcoa ={4006}, portfolio = {"IC*"} >} cur_amount )

Re: How to restrict values in a dimension

paul_ripley — Fri, 23 Oct 2020 14:39:22 GMT

Just FYI I created a calculated dimension as so =if(wildmatch(portfolio, 'IC*'), portfolio)

Kind regards

Paul