Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Expressions in Fixed Number Limitations?

Hi,

I'd like to have the fixed number limitation display the bottom 20 results where "UnitsSold" <> 0.

Unchecking "Include Zero Values" makes it return no results at the moment.

Is this possible using expressions?

Thanks,

Keiran

Tags (1)
4 Replies
vkish16161
Contributor III

Re: Expressions in Fixed Number Limitations?

Can you please explain what your requirement is more clearly with example?

Not applicable

Re: Expressions in Fixed Number Limitations?

Here is an example table:

ItemCode

ItemPrice

UnitsSold

TotalValue

A1

£1

0

£0

A2

£2

1

£2

A3

£5

10

£50

"ItemCode" currently has a fixed number limitation calculated on "UnitsSold" to the bottom twenty. We would like to filter out any results where UnitsSold = 0.

shraddha_g
Honored Contributor III

Re: Expressions in Fixed Number Limitations?

Share screenshot of expression you used and output you are getting without unchecking "Include Zero Value".

vkish16161
Contributor III

Re: Expressions in Fixed Number Limitations?

Based on what I understood, you could try this.

IN A TEXT BOX,

Concat({<UnitsSold={0}>}ItemCode,',')

This will give you a list of ItemCodes where UnitsSold = 0

If this doesn't work you can try:

Concat (

Aggr (

if(Sum(UnitsSold) =0,ItemCode )

, ItemCode )

, ',')

Community Browser