Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set analysis as well as matching text/numbers

I have a set analysis expression

 

sum

({$<[Date] = {">=$(=addmonths(max(Date),-$(vSelectNoOfMonths)+1))<=$(=max(Date))"}>}[Accidents Count ID])

The above is working fine but I wish to further filter the analysis by only having the above for records where a field 'Immediate Cause' is populated by a number of values such as '12i', '12j','12k' etc etc. I have tried adapting the like/match commands but cannot combine those with the set analysis expression above

Any ideas please?

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Set analysis as well as matching text/numbers

Hi,

Easier than it seems!

Sum({< [Date] = {">=$(=addmonths(max(Date),-$(vSelectNoOfMonths)+1))<=$(=max(Date))"}, [Immediate Cause] = {"12*"} >} [Accidents Count ID])

That will check for all values starting by "12"

Hope that helps,

Miguel

1 Reply
MVP
MVP

Re: Set analysis as well as matching text/numbers

Hi,

Easier than it seems!

Sum({< [Date] = {">=$(=addmonths(max(Date),-$(vSelectNoOfMonths)+1))<=$(=max(Date))"}, [Immediate Cause] = {"12*"} >} [Accidents Count ID])

That will check for all values starting by "12"

Hope that helps,

Miguel

Community Browser