Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
bharatkishore
Creator III
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
Gysbert_Wassenaar

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

View solution in original post

2 Replies
Gysbert_Wassenaar

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

View solution in original post

bharatkishore
Creator III
Creator III
Author

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

Regards,

Bharat