topic Re: Condition to bring 2 trendlines? in QlikView

Condition to bring 2 trendlines?

Tue, 06 Aug 2013 18:24:50 GMT

Hi,

Please find the attached image file and excel.

I am having 2 products named X and Z in my excel.

and the values i am using are for the trend line is sum(TEB).

This [sum(if(date>= date(today()-91), TEB))] expression helped me to get the 13 weeks data for sum of both X and Z.

For the same query, I want to display 2 trendlines for X and Z.

How do i get this? Do I have to try with a if condition? (I want to keep this query also [sum(if(date>= date(today()-91), TEB))] in the condition.

Thanks in advance.

Tue, 06 Aug 2013 20:26:24 GMT

Hi,

what about using ProductName as the second Dimension ?

Roland

Wed, 07 Aug 2013 16:50:10 GMT

My apologize. I had taken a wrong excel to pull the data.

I got the dimension now.

Thank you Roland.