Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

zach_paz
New Contributor II

Fractile a dynamic variable?

Hi all,

I am trying to fractile a dynamic variable that ignores all selections.

Variable:

  • vMetric = sum(sales)

Aggregate by:

  • Product

Tables:

  • Percentile
    • This is a table that has 0% to 100% by 10% increments and is used as the

Current expression:

=fractile({1<Market=P(Market)>}aggr(nodistinct ($(vMetric)),Product,Market),1)

I need to have a table that has the percentiles by each decile by two dimensions:

  1. Percentile
  2. Market


Please help!


Tags (2)
1 Solution

Accepted Solutions

Re: Fractile a dynamic variable?

If you want the expression to ignore all selections the you need to change the expression in the variable too: sum({1} sales).


talk is cheap, supply exceeds demand
1 Reply

Re: Fractile a dynamic variable?

If you want the expression to ignore all selections the you need to change the expression in the variable too: sum({1} sales).


talk is cheap, supply exceeds demand
Community Browser