Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siddharthsoam
Partner - Creator II
Partner - Creator II

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.

2 Replies
petter
Partner - Champion III
Partner - Champion III

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)

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

Hi Petter,

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