topic Re: Different state in one table in QlikView

Different state in one table

Thu, 27 Oct 2016 07:06:43 GMT

Hello All,

I have a straight table as shown below:

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

Is it possible?

Many Thanks,

Hasvine

Re: Different state in one table

HirisH_V7 — Thu, 27 Oct 2016 08:29:38 GMT

Hi,

You can use this expression,

IF it is , Sum(Cumul) means

Sum({<Question=>}Cumul)

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

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

HTH,

Hirish

Re: Different state in one table

sunny_talwar — Thu, 27 Oct 2016 09:25:21 GMT

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?