topic Re: Set analysis in QlikView

Set analysis

MindaugasBacius — Fri, 17 Jun 2016 07:48:11 GMT

Hei,

Can we use calculated expression from pivot/straight table in the same pivot/straight table as a field in Set analysis?

I have tried and it doesn't work.

Maybe I am doing something wrong or maybe it's not possible

Re: Set analysis

MK_QSL — Fri, 17 Jun 2016 07:52:56 GMT

can you provide your expression / Calculated dimension please?

Re: Set analysis

marcus_sommer — Fri, 17 Jun 2016 07:54:24 GMT

You could include set analysis within the calculation of a calculate dimension - but you need to wrap these expression within an aggr-function, see for this: Calculated Dimensions.

- Marcus

Re: Set analysis

Kushal_Chawda — Fri, 17 Jun 2016 07:57:30 GMT

If i understood correctly , You can do something like this

I am giving just example below, you can change your expression accordingly

1st Expression:

=Sum(Sales{<Typ1={1}>}Sales)

2nd Expression:

=Count({<Dimension ={"=Sum(Sales{<Typ1={1}>}Sales)>0"}>}ID)

If not then explain your scenario

Re: Set analysis

MK_QSL — Fri, 17 Jun 2016 08:01:35 GMT

What is =Sum(Sales{<Typ1={1}>}Sales)? kush141087

Re: Set analysis

Kushal_Chawda — Fri, 17 Jun 2016 08:04:43 GMT

thats typo or you can consider as State

Re: Set analysis

MK_QSL — Fri, 17 Jun 2016 08:09:14 GMT

I will consider as State.. LOL... (Good answer)

Re: Set analysis

Kushal_Chawda — Fri, 17 Jun 2016 08:13:05 GMT

But if it is state ,syntax is incorrect. lol.. should be like below i think

Sum({Sales<Typ1={1}>}Sales)