Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to ORGANISE QV report on Compute sales vs GP % for particular company

Hi All

I have created few these before .  But I often unable to find them. So I hope some one can share with me how you do it ?

For example I can do it by :-

1. Chart bar display sales and line display GP %

2. Pivot Table with 2 column on is sales and other GP % .

3. SET  analysis table sales  and GP % Table show last 3 yr data.

Which is the best ? And how you organise them . So that it can be find it Quickly.

Paul

2 Replies
jagan
Partner - Champion III
Partner - Champion III

HI Paul,

Try like this

1. Chart bar display sales and line display GP % -- Use Combo chart, bar for sales and line for GP%

2. Pivot Table with 2 column on is sales and other GP % .

3. SET  analysis table sales  and GP % Table show last 3 yr data. - Sum({<Year={'>=$(=Max(Year)-3)'}>} Sales)

Hope this helps you.

Regards,

Jagan.

paulyeo11
Master
Master
Author

Hi Japan

Many thank for your reply. My issue is not about how to create the 3 report. My issue is about org the report. As after certain period we will have many report. If not org well . It will be difficult to look for the report. So I just hope some one can share about this .

Paul