Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

panipat1990
Contributor II

Need help on Expression Enable condition:-

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

5 Replies

Re: Need help on Expression Enable condition:-

please close your open threads that received correct answers.

thanks

regards

Marco

panipat1990
Contributor II

Re: Need help on Expression Enable condition:-

Dear Marco

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

Thanks

Gourav

satheshreddy
Contributor III

Re: Need help on Expression Enable condition:-

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:-

vishsaggi
Esteemed Contributor III

Re: Need help on Expression Enable condition:-

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