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

how to show percentages of only two years in pie chart

bvssudhakar — Wed, 25 Nov 2020 16:16:04 GMT

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

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

bvssudhakar — Fri, 14 Sep 2018 11:44:13 GMT

Hi franky_h79‌stalwar1‌mbaeyens‌

Can you guys please look for this and help me out

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

tresB — Fri, 14 Sep 2018 11:55:16 GMT

Like this?

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

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

bvssudhakar — Fri, 14 Sep 2018 12:00:52 GMT

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)

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

tresB — Fri, 14 Sep 2018 12:18:55 GMT

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.

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

bvssudhakar — Fri, 14 Sep 2018 12:30:56 GMT

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

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

bvssudhakar — Fri, 14 Sep 2018 12:32:04 GMT

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