Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

KumaRan
New Contributor

Reference line for Selected months

Hi all

I need to show reference line in chart.following expression is working  if i select any one month or 2 or 3 consecutive months. if i select random months answer was not correct. can anyone suggest?

    (NetWorkDays(Date(min(Date),'DD-MMM-YYYY'),Date(max(Date),'DD-MMM-YYYY'),$(v_Holiday)) * 8.5))

for examlpe

     apr-170 hrs

     may-187 hrs

     june-178.5 hrs

    July-178.5 hrs

    aug-178.5 hrs

    Sep-76.5 hrs

From the above if i choose apr&may combination- 357

                                        may&june combination-365.5

                                         apr& june combination- 535.5(apr+may+june) (but i need to get 348.5 for Apr & june)

5 Replies
mdmukramali
Valued Contributor II

Re: Reference line for Selected months

Hi,

Can you share sample data Application.

Thanks,

Mukram

shraddha_g
Honored Contributor III

Re: Reference line for Selected months

Share sample app

KumaRan
New Contributor

Re: Reference line for Selected months

PFA

rajeshthakur292
Contributor II

Re: Reference line for Selected months

Hi,

Please find attached the updated app.!

Hope it meets your requirement.

Cheers!

KumaRan
New Contributor

Re: Reference line for Selected months

Hi Rajesh

  Thank you for your time. its working fine. but my question is ,in future if months are added, do i need to modify expression isn't?

    If answer for the above question is YES i need to automate it without adding any expression.Kindly can you suggest?