Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

siddharthsoam
Contributor

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
MVP
MVP

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)

siddharthsoam
Contributor

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?

Community Browser