Need help on Expression Enable condition:-

[panipat1990]

Hi Team,

I have one requirement on Expression enable condition.

We have 3 years i.e 2016 , 2015 and 2014 data with sales value. We have to design trend chart for above 3 years.

Month will be dimension and Sales value is our measure field And Year as a selection filter..

Requirement is when we select 2016 and 2015 both year at a time then Two trend line should be seen in line chart. And when I select 2014 and 2016 then related trend line should be shown in same line chart.

After doing  2014 and 2015 year selection then related trend line should  be shown in same Line Chart..

Have attached the data for your reference. Kindly help me over this.

Thanks

Gourav

[MarcoWedel]

please close your open threads that received correct answers.

thanks

regards

Marco

[panipat1990]

Dear Marco

I have closed my open threads. Please help me on above requirement...

Thanks

Gourav

[satheshreddy]

Hi Gourav,

This time you have to create three exp in line chart you will easily reach your requirement.

Dimention is month and expretion is

1).sum(sales).

2).sum(sales).

3).sum(sales).

need to write condition if(Year=2016,1,0) for all Exp for shwoing.

Regards

Sathish

[MarcoWedel]

maybe helpful:

Qlik Community Tip: Marking Replies as Correct or Helpful

regards

Marco

[vishsaggi]

Check attached, if this is what you are looking for?