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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
alan_grn
Creator II
Creator II

Top 10 in a line graph

I am trying to draw a line graph for the top x customers.

The code fro the line graph is currently

(

SUM({$<[Business Date]={$(='"<='&DATE(MAX([Business Date]))&'"')}>} [Cr Balance]))

The code for the Top X is

IF

(Aggr ( Rank ( Sum (if([Business Date]=$(vSelectedDate), [Cr Balance] ))) , [Cin Name] ) <= $(vTop) , Sum ( if([Business Date]<=$(vSelectedDate),[Cr Balance] )) )

Both of these work, but how do I put them together?

What I would also like to do is then draw a line for the minimum balance for the sum of the top x customers (i.e. a flat line)











0 Replies