Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to convert my chart rEVENUE Amt by month ( 1 Line chart ) to 2 line using only 1 expression for eask compare CY vs LY ?

Hi All

Chart 1 is good. Because only 1 expression & expression is very shot , it can plot 2 line. Expression as below :-

Sum(

{<Year={'>$(=year(today())-2)'}>}

sales)

Chart 2 is working fine too , but i like it present like chart 1 format. So that i can easily compare with LY trend. Chart 2 Expression as below :-

sum({<rEVENUE={"rEVENUE"}>}Amount)

My imagine of the final expression ( chart 3 )as below :-

Sum(

{<Year={'>$(=year(today())-2)'}>}

{<rEVENUE={"rEVENUE"}>}Amount

)

How to make chart 3 display format same as chart 1 ? by not display 2014 line ? ( Take note that Chart 1 only display 2015 and 2016 line )

Paul

1 Solution

Accepted Solutions

Re: How to convert my chart rEVENUE Amt by month ( 1 Line chart ) to 2 line using only 1 expression for eask compare CY vs LY ?

Are you looking for this?

Capture.PNG

7 Replies

Re: How to convert my chart rEVENUE Amt by month ( 1 Line chart ) to 2 line using only 1 expression for eask compare CY vs LY ?

Are you looking for this?

Capture.PNG

paulyeo11
Valued Contributor II

Re: How to convert my chart rEVENUE Amt by month ( 1 Line chart ) to 2 line using only 1 expression for eask compare CY vs LY ?

Hi Sunny

Thank you finally my chart now look perfect.

Paul

paulyeo11
Valued Contributor II

Re: How to convert my chart rEVENUE Amt by month ( 1 Line chart ) to 2 line using only 1 expression for eask compare CY vs LY ?

Hi Sunny

Can you sharing with me , why after you remove the below , the chart look fine ?

,>}{<

Paul

Re: How to convert my chart rEVENUE Amt by month ( 1 Line chart ) to 2 line using only 1 expression for eask compare CY vs LY ?

Remove? What did I remove?

paulyeo11
Valued Contributor II

Re: How to convert my chart rEVENUE Amt by month ( 1 Line chart ) to 2 line using only 1 expression for eask compare CY vs LY ?

Hi Sunny

My Org imagine code not working :-

Sum(

{<Year={'>$(=year(today())-2)'}>}

{<rEVENUE={"rEVENUE"}>}Amount

)

why your code is working :-

Sum(

{<Year={'>$(=year(today())-2)'}, rEVENUE={'rEVENUE'}>}Amount

)

Because you remove below away , and it work.

,>}{<


I like to know why ?


Paul

Re: How to convert my chart rEVENUE Amt by month ( 1 Line chart ) to 2 line using only 1 expression for eask compare CY vs LY ?

Because the one you used was incorrect syntax for set analysis. Set Analysis conditions are separated by comma -> {<Field1 = {'SomeValue'}, Field2 = {'AnotherValue'}>}

paulyeo11
Valued Contributor II

Re: How to convert my chart rEVENUE Amt by month ( 1 Line chart ) to 2 line using only 1 expression for eask compare CY vs LY ?

Hi Sunny

Thank you very much for your explanation.

Paul

Community Browser