Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

n1ef5ng1
Contributor

Comparative Analysis

Hi all,

I am using comparative analysis to do an ad hoc template for user to nagivate around. (Aka alternate state)

On the Script I have this code

_Dimension_PMX:

LOAD * INLINE [
_Dimension_PMX
Box
TEU

this means that if user check on TEU, the table will appear box on expression using conditional format

  =SubStringCount(Concat(_Dimension_PMX, '|'), 'TEU')

and my expression to that conditional expression is

sum({[Group 1]}TEU)

However, for this report i woud like my expressions to have set analysis where Activity_Code = 'LOAD'. This is to cater a certain ad hoc template for this

meaning if is without alternative anaysis, it will be sum({<Activity_Code = {'LOAD'}>}TEU)

I would not want user to select Load activity code everytime as it defeat the purpose

thanks!

6 Replies
n1ef5ng1
Contributor

Re: Comparative Analysis

anybody.....

vikasmahajan
Honored Contributor III

Re: Comparative Analysis

Please Try Following


Conditional

=SubStringCount(Concat(_Dimension_PMX,','),'TEU')>=1


And expression


sum({[Group 1]}TEU)

n1ef5ng1
Contributor

Re: Comparative Analysis

i think this is not the answer that i am looking for. I am able to do comparative analysis

say if the user select some selection and the TEU is 200, out of these 200, on activity_code = LOAD, it only containes 80. Therefor, my expression would want to show 80 instead of 200. I must put Activity _Code - load on the expression.

sum({<Activity_Code = {'LOAD'}>}TEU) plus comparative analysis of sum(Group 1 teu)

Thanks

vikasmahajan
Honored Contributor III

Re: Comparative Analysis

sum({Group1<Activity_Code = {'LOAD'}>}TEU)

Please try this.

Vikas

n1ef5ng1
Contributor

Re: Comparative Analysis

thanks!

vikasmahajan
Honored Contributor III

Re: Comparative Analysis

PFA Sample

Vikas

Community Browser