topic Re: Why my GP% chart can display Jan and Feb % ? in QlikView

Why my GP% chart can display Jan and Feb % ?

paulyeo11 — Mon, 24 Feb 2020 02:47:41 GMT

Hi All

I have a table it can display monthly GP% amount.

YearMonth year 2019 2020
19 Jan 22% -
19 Feb 30% -
19 Mar 23% -
19 Apr 29% -
19 May 28% -
19 Jun 40% -
19 Jul 31% -
19 Aug 29% -
19 Sep 33% -
19 Oct 27% -
19 Nov 29% -
19 Dec 41% -
20 Jan - 28%
20 Feb - 29%

when i plot the chart , it can only display Jan and Feb ?

Paul Yeo

Re: Why my GP% chart can display Jan and Feb % ?

paulyeo11 — Mon, 24 Feb 2020 02:48:30 GMT

Hi All

Enclosed my QVW

Re: Why my GP% chart can display Jan and Feb % ?

prma7799 — Tue, 03 Mar 2020 12:13:23 GMT

Hi Paul ,

Could you please share some sample data with expected output.

I am not able to open your qvw file

Thanks

Re: Why my GP% chart can display Jan and Feb % ?

paulyeo11 — Tue, 03 Mar 2020 12:15:18 GMT

Hi Sir

I have found the issue , it is due to my expression. Now work fine.

Paul

Re: Why my GP% chart can display Jan and Feb % ?

Anil_Babu_Samineni — Tue, 03 Mar 2020 12:17:36 GMT

The expression quite wrong to me in this section

year = {">=$(=max(year),4)"}

Re: Why my GP% chart can display Jan and Feb % ?

paulyeo11 — Tue, 03 Mar 2020 13:05:37 GMT

Hi Sir

I have replace with below , it work fine :-

(
sum(sales)
-
sum(cost)
)
/
sum(sales)

Paul