

Master
2020-02-23
09:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Why my GP% chart can display Jan and Feb % ?
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
1,000 Views
1 Solution
Accepted Solutions


Master
2020-03-03
08:05 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sir
I have replace with below , it work fine :-
(
sum(sales)
-
sum(cost)
)
/
sum(sales)
Paul
909 Views
5 Replies


Master
2020-02-23
09:48 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi All
Enclosed my QVW
996 Views

Master III
2020-03-03
07:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Paul ,
Could you please share some sample data with expected output.
I am not able to open your qvw file
Thanks
926 Views


Master
2020-03-03
07:15 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sir
I have found the issue , it is due to my expression. Now work fine.
Paul
I have found the issue , it is due to my expression. Now work fine.
Paul
920 Views
2020-03-03
07:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The expression quite wrong to me in this section
year = {">=$(=max(year),4)"}
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
917 Views


Master
2020-03-03
08:05 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sir
I have replace with below , it work fine :-
(
sum(sales)
-
sum(cost)
)
/
sum(sales)
Paul
910 Views
