Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ashish_2511
Creator
Creator

Nested Set Analysis - New

Dear Community

I know this topic has been discussed a lot but I couldn't find anything relevant to my problem. So here's my problem

I have to write a pivot table  expression like this -

Count(Distinct {<only({<$(vServTarg_ExcludeSelections)>}MTM_COUNTER)=1,
Sum({<BV_DETAIL_LATEST_FLAG={1},
$(vServTarg_ExcludeSelections)>}BV_D_COUNTER)=0,
Sum({<YM_ACTI={
$(vMonth0),$(vMonth1),$(vMonth2),$(vMonth3),$(vMonth4),$(vMonth5)}, ACTIVITY_SERVICE_TYPE = {'HT', 'LT'}>}ACTIVITY_COUNTER)>0 >}
CONTACT_ID)


Unfortunately it won't work. Also I cannot write it using 'If' as it won't allow nested aggregation.

Please suggest.

Thanks in advance

Sneh

14 Replies
jyothish8807
Master II
Master II

Try like this then,

count(distinct If([MTM_COUNTER]=1 and Sum({<BV_DETAIL_LATEST_FLAG={1}>}BV_D_COUNTER)=0 and Sum({<ACTIVITY_SERVICE_TYPE = {'HT', 'LT'}>}ACTIVITY_COUNTER)>0,[Contact ID]))

Br,

KC

Best Regards,
KC
ashish_2511
Creator
Creator
Author

Fantastic! this is what I was looking for. A small problem though - I've calculated dimensions . do you have something else that would work with calculate dimensions?

Thanks for all the help so far

Cheers!

Sneh

ashish_2511
Creator
Creator
Author

Thanks for that. I'm afraid this isn't working as nested aggregation is not possible in 'If' but having a aggr function around will make it work as Jonathan suggested above.

Thanks!

sunny_talwar

May be you can perform the calculated dimension's calculation in the script?

gloria_bertini
Creator
Creator

Hi,

i don't know if it can be useful for you case, but maybe you can try syntax for nested set analys like proposed in this thread

set-analysis lost customers

regards