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

Announcements
Catch up on the newest Qlik features and improvements: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

Trellis Cotnainer

Hello
I got a master visualization which is a combo chart with 3-bars expressions (stacked) and a line expressions
the combo chart looks something like this:

ali_hijazi_0-1793347735406.png


Now what I want is to break this chart by the top 8 accounts but the trellis is repeating the chart for all 8 accounts

ali_hijazi_1-1793348047434.png

I put advanced mode and added to the expressions the $(vDimSet) and in the dimension I put the following dimension:
=Aggr(
If(
 Rank(Sum({<[Portfolio Level 2 ID]={87}, SCENARIO_TYPE, SCNR_TYPE_ID={0}>} AMOUNT * MANDAYS_SPENT * FLG_MANDAYS_SPENT_INCL_DU), 4) <= 8,
ACCOUNT_DESCRIPTION
),
ACCOUNT_DESCRIPTION
)

but all in vain
I also put the ACCOUNT_DESCRIPTION as the dimension in the trellis and moved the logic of the ranking to the expressions but trellis displays blanks or diplays 1 bar expression and repeating it as above
i tried to put 8 distinct charts but the performance is extremely slow
kindly advise

I can walk on water when it freezes
Labels (3)
0 Replies