Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Not applicable

(((Line1 - Line2) = Line3) - Line4) = Line5 (Pivot Table)

Hi!

I'm really struggling with this.

Need to create a pivot table with 2 colums like this:

A

    101

B

    201

    202

    203

C

D

    401

    402

    403

E

Lines at the second colum (that don't end in "0" (zero) are my data.

Lines at the first colum are the calculated Dimensions. See:

A (= 101)

    101

B (= 201 + 202 + 203)

    201

    202

    203

C (= A - B)

D (= 401 + 402 + 403)

    401

    402

    403

E (= C - D)

I already know how to do A, B and D. To achieve that I've added a Calculated Dimension with:

=Pick(WildMatch(......)......)

This made it group the lines:

101 inside A

201, 202 and 203 inside B

401, 402 and 403 inside D

I'm strugling with C and E, because I need them to be at the same Colum. (if the only way to do this, is with C and E at a different colum, unfortunately, then so be it.)

Can you help me?