2 Replies Latest reply: Apr 13, 2018 6:17 AM by siddharth soam

# Need to show only specific accounts correponding to condition Qliksense

Hi,

I need to show 20 accounts in dimension 'm' showing in pivot where

Qualifier 1:sales for FY17 >'1'

Qualifier 2:Profit is negative (bottom 20 accounts) corresponding to YTD FY18

Pfa of the qvf attached.

• ###### Re: Need to show only specific accounts correponding to condition Qliksense

I believe this should work for you:

Define the dimension M with this expression

=Aggr( Only(

{\$<M={"=

Sum({\$<[Fiscal Year]={\$(=\$(Previous_to_max_year))},Quarters=>} Sales) > 1

AND

(Sum({\$<[Fiscal Year]={\$(=\$(max_year))},Quarters={\$(=\$(ytd_prev_year_quarter))},[Month Name]={\$(=\$(ytd_prev_year_month))}>}Profit)/ Sum({\$<[Fiscal Year]={\$(=\$(max_year))},Quarters={\$(=\$(ytd_prev_year_quarter))},[Month Name]={\$(=\$(ytd_prev_year_month))}>}Sales))

< 0

"}>}M),M)

• ###### Re: Need to show only specific accounts correponding to condition Qliksense

Hi Petter,

I want to limit my bottom accounts to 20. Where can I change it in the expression?