Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to copy line chart from sheet B to sheet A ?

Hi All

I need to copy sheet B chart to here , it is a line chart line chart which work fine ( can view from sheet B ):-

When SOURCE=TDSS is trun on.

Dimension = month

Expression =

Aggr( Rangesum( Above( Sum( {<Year={'>$(=year(today())-2)'}, nET_PROFIT={'nET_PROFIT'}>}Amount )/Rate ,0,rowno())) ,year,(month,(NUMERIC,ASCENDING)))

 

My issue is when i copy over to here (Sheet A) , the chart does not display any thing. ( I have no issue copy other bar chart and line chart from sheet to sheet ).

May i know where i go wrong ? ( i Does not use any extension )

Paul

5 Replies
robert_mika
Master III
Master III

Please see attached.

paulyeo11
Master
Master
Author

Hi Robert

After you copy over to sheet A , if you select SOURCE = TDSS , IT should display chart look like Sheet B. now the chart in sheet A not working.

Paul

robert_mika
Master III
Master III

Some of your measures are defined as alternative.

When your copy /paste chart from one sheet to another they will probably keep the state from the source sheet.

paulyeo11
Master
Master
Author

Ok thank you for yr sharing . I will try again.

Paul Yeo

Director

www.tdstech.com<http://www.tdstech.com>

HP+6285883521036 Indo

paulyeo11
Master
Master
Author

Hi Robert

May I know why I am not able to create the chart I want ? I mean I try to copy the expression to brand new chart , it does not work .

Paul Yeo

Director

www.tdstech.com<http://www.tdstech.com>

HP+6285883521036 Indo