Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

bvssudhakar
Contributor

how to show percentages of only two years in pie chart

Hi Experts,

I have Different Date columns and i have created master calendar linked with those columns and i have created charts also those all are correct but now i got one more requirement which it is:

I want to create pie chart and show the the percentage of only FY:2017 and FY:2018

For that I wrote the Expression like this:

=count({<Recruiter={'Irfan Memon','Rajiv Ranjan','Aditi Saxena','Sneha Singh'},Date_Flag={'DeclineDate'}, Year ={2017,2018}>}CandidateID)

/

count({<Recruiter={'Irfan Memon','Rajiv Ranjan','Aditi Saxena','Sneha Singh'},Date_Flag={'offerdate'}, Year={2017,2018}>}CandidateID)

But i want it for FY:2017 and FY:2018

Can you guys please suggest me how to achieve this. For your reference here i am attaching my qvw also. Please check it and give your valuable suggestions

Note: I want to show only those two years percentage (e.g. if 2017 Percentage is :16, and 2018's is 30% like this)

Thank you in advance

1 Solution

Accepted Solutions
MVP
MVP

Re: how to show percentages of only two years in pie chart

Like this?

Capture.JPG

If so, uncheck 'Relative' in expression tab and check 'Show in Percent %' in number tab.

6 Replies
bvssudhakar
Contributor

Re: how to show percentages of only two years in pie chart

Hi franky_h79stalwar1mbaeyens

Can you guys please look for this and help me out

MVP
MVP

Re: how to show percentages of only two years in pie chart

Like this?

Capture.JPG

If so, uncheck 'Relative' in expression tab and check 'Show in Percent %' in number tab.

bvssudhakar
Contributor

Re: how to show percentages of only two years in pie chart

Hi Tresesco,

Yeah Like this only, But I want to create for Financial year 2017 and Finacial Year 2018  (e.g.March-2017 to April 2018 like this way)

MVP
MVP

Re: how to show percentages of only two years in pie chart

So, your actual calendar is normal calendar (year starts with Jan), however, you want this pie representation to show the FY data, right? If so, you could use date in the set analysis instead like,

=count({<Recruiter={'Irfan Memon','Rajiv Ranjan','Aditi Saxena','Sneha Singh'},Date_Flag={'DeclineDate'},

LinkDate={">=$(=Date(MakeDate(2017,4,1))) <=$(=Date(MakeDate(2018,3,1)))"}>}CandidateID)

/

count({<Recruiter={'Irfan Memon','Rajiv Ranjan','Aditi Saxena','Sneha Singh'},Date_Flag={'offerdate'},

LinkDate={">=$(=Date(MakeDate(2017,4,1))) <=$(=Date(MakeDate(2018,3,1)))"}>}CandidateID)

Now, if you need to make it dynamic or selection-proof, you have to adjust the expression accordingly.

bvssudhakar
Contributor

Re: how to show percentages of only two years in pie chart

Can you please adjust the expression for selection and dynamic proof way

and

again i have doubt for this expression also: I want to show it for 2 year FY's. can you please modify for me

bvssudhakar
Contributor

Re: how to show percentages of only two years in pie chart

Can you please adjust the expression for selection and dynamic proof way

and

again i have doubt for this expression also: I want to show it for 2 year FY's. can you please modify for me... Means Current FY still going na so that how to modify