Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Different state in one table

Hello All,

I have a straight table as shown below:

ping.PNG

I would like my last column 'Cumul' to ignore my current selection and use my set analysis.

Is it possible?

Many Thanks,

Hasvine

2 Replies
hirishv7
Honored Contributor

Re: Different state in one table

Hi,

You can use this expression,

IF it is , Sum(Cumul) means

Sum({<Question=>}Cumul)

or

IF it is ,Sum({<Question={'Satisfaction*'}>}Cumul) means

Sum({1<Question={'Satisfaction*'}>}Cumul)


HTH,

Hirish

MVP
MVP

Re: Different state in one table

I think it is possible to use alternate state, but not sure what your expressions are, so difficult to give any suggestions. Would you be able to provide a sample for us to look at?