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

YTD Current Ratio Table it is possible to convert to Current Ration Trend line.

Hi All

I have a Current ratio Table 1 which give me correct result. as below :-

March 2013 Current Ratio = 50.55% ( when month = 3 & year = 2013

Feb 2013 Current Ratio = 47.62% ( when month = 2 & year = 2013

The issue is of the above table it only allow to show me Current Ratio for one period.  Now my aim is view the trend line of Current Ratio By MonthYear. what i did is i add YearMonth field at diamension. and it does able to plot the trend line of current ratio. But the result is not correct.

Hope some one can advise me how to do it.

Paul

1 Reply
paulyeo11
Master
Master
Author

Can some one with very powerful on aggr or advise me ?