topic Re: IF in a calculated dimension in QlikView

IF in a calculated dimension

meckeard — Sat, 16 Nov 2024 02:36:08 GMT

Hi All,

I have a bar chart that shows customer ages along the X axis with the count of customer with that age along the Y axis. The dimension for this uses a field called Cust_Age. That works fine but I need to only get the Cust_Age for 6 of my company locations that are in a field called Freq_BranchName. I tried to update my dimension to a calculated Dimension like this:

=If(Match(Freq_BranchName, 'Blue Bell', 'Havertown', 'Lawrence Park', 'Limerick', 'Secane', 'Springfield' ), Cust_Age)

This didn't work. It seemed to sum all the values for Cust_Age.

I tried to put this logic in the "Enable Conditional" field but that made no change to my graph:

Match(Freq_BranchName, 'Blue Bell', 'Havertown', 'Lawrence Park', 'Limerick', 'Secane', 'Springfield' )

What can I do to get only Cust_Age where Freq_BranchName is equal to the 6 names above?

Thanks!

Re: IF in a calculated dimension

dplr-rn — Thu, 29 Aug 2019 17:28:02 GMT

in your expression use set analysis like below

Sum({<Freq_BranchName={'Blue Bell', 'Havertown', 'Lawrence Park', 'Limerick', 'Secane', 'Springfield'}>}Sales)

Re: IF in a calculated dimension

meckeard — Thu, 29 Aug 2019 17:51:20 GMT

Dilipranjith,

Thanks, that was close to what I needed and I was able to get it to work.

Mark

Re: IF in a calculated dimension

dplr-rn — Thu, 29 Aug 2019 17:52:19 GMT

good to hear