topic Re: Need help on Expression Enable condition:- in QlikView

Need help on Expression Enable condition:-

panipat1990 — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Need help on Expression Enable condition:-

MarcoWedel — Sun, 09 Apr 2017 23:05:35 GMT

please close your open threads that received correct answers.

thanks

regards

Marco

Re: Need help on Expression Enable condition:-

panipat1990 — Mon, 10 Apr 2017 05:04:36 GMT

Dear Marco

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

Thanks

Gourav

Re: Need help on Expression Enable condition:-

satheshreddy — Mon, 10 Apr 2017 06:31:23 GMT

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

Re: Need help on Expression Enable condition:-

MarcoWedel — Tue, 11 Apr 2017 18:34:24 GMT

maybe helpful:

Qlik Community Tip: Marking Replies as Correct or Helpful

regards

Marco

Re: Need help on Expression Enable condition:-

vishsaggi — Tue, 11 Apr 2017 19:09:42 GMT

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