# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for
Did you mean:
Creator III

## Chart Expression

Dear All,

I am using a Pivot chart. I have taken one name dimension and one stage dimension(Total 2 Dimension). In that stage(Field) dimension i have 6(Sub- fields) i.e.

1)Achieved

2)Breached

3)Cancelled

4)Inprogress

5)Manually Cancelled and

6)In Progress

Attached image for your reference..

Now i have written an expression for calculating the count task number i.e.

=count({<name={'MOET HENNESSY ASIA PACIFIC/HK'},[Link Date]={'>=\$(VarLase4Month) <=\$(VarFinMaxDate)'},[Fiscal Month]=,[FY Year Name]=>} task_number)

Now my problem is I need calculate the two subfields i.e. and i need to display those calculated ones in the pivot chart...

1)Achieved + Breached

2)Achieved/Achieved+Breached

Can you please suggest me how can i achieve this.

Regards,

Bharat

1 Solution

Accepted Solutions

Perhaps you can use 8 expressions and remove the status dimension:

Create an expression vExpr and use this in the expressions

vExpr: count({<stage={\$1}, name={'MOET HENNESSY ASIA PACIFIC/HK'},[Link Date]={'>=\$(VarLase4Month) <=\$(VarFinMaxDate)'},[Fiscal Month]=,[FY Year Name]=>} task_number)

1) Achieved: \$(vExpr('Achieved'))

2) Breached: \$(vExpr('Breached'))

3) Cancelled: \$(vExpr('Cancelled'))

4) Inprogress: \$(vExpr('Inprogress'))

5) Manually Cancelled: \$(vExpr('Manuallycancelled'))

6) In Progress: \$(vExpr('Inprogress'))

7) Achieved + Breached: [Achieved] + [Breached]

😎 Achieved/Achieved + Breached: 1 + [Breached]

talk is cheap, supply exceeds demand
2 Replies

Perhaps you can use 8 expressions and remove the status dimension:

Create an expression vExpr and use this in the expressions

vExpr: count({<stage={\$1}, name={'MOET HENNESSY ASIA PACIFIC/HK'},[Link Date]={'>=\$(VarLase4Month) <=\$(VarFinMaxDate)'},[Fiscal Month]=,[FY Year Name]=>} task_number)

1) Achieved: \$(vExpr('Achieved'))

2) Breached: \$(vExpr('Breached'))

3) Cancelled: \$(vExpr('Cancelled'))

4) Inprogress: \$(vExpr('Inprogress'))

5) Manually Cancelled: \$(vExpr('Manuallycancelled'))

6) In Progress: \$(vExpr('Inprogress'))

7) Achieved + Breached: [Achieved] + [Breached]

😎 Achieved/Achieved + Breached: 1 + [Breached]

talk is cheap, supply exceeds demand
Creator III
Author

Thanks a lot Gysbert....It worked..

Regards,

Bharat