Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense 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