Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

aaronnayan
Contributor

Chart to show all Values when 0 and filtered down upon

Hi Guys,

Bit of a technical question.

I need my chart to show certain values when they are null

I have 5 items

Tshirts

Jeans

Shirts

Shoes

Accessories

Only some [Shops] have these items.

In [Reporting period] only some of these items have been sold depending on time.

I want when i filter down to show all the null values that are assoicated to each shop and Reporting Period

For example: London shop only sells Tshirts and Jeans. Birmingham shop sells Shoes and accessories.

If i filter on London I want to see all the items that did not sell, The 0s basically.

I have been able to achieve what I want when I filter on shop but not on Reporting period.

Sum({<Shop+={' '}>}[Item])

Is there a way to add in reporting period? To make the result dynamic to the two filters? ([Shop], [Reporting Period])

Thanks,

Aaron

1 Reply
MVP
MVP

Re: Chart to show all Values when 0 and filtered down upon

Would you be able to share few rows of sample data and let us know what is the expected output you are looking to get with or without selection in reporting period?