Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Partner
Partner

sales disregard a selection

hi all,

very simple,

one fact table of sales with fields item id, customer id, and quantity

two tables of items and customers. linked to the sales table.

and the items  table has some flag of special items.

I want to show the sales in a chart of all items that flagged.

but if I select a customer the chart should show all items that flagged even if the this customer I select

didn't buy some items that flagged.

please help

thanks,

dt

18 Replies

Re: sales disregard a selection

Add artificial "zero" records to your sales table, i.e. records for every customer and every is_pl=1 product with a quantity set to 0.

Good luck,

Peter

MVP
MVP

Re: sales disregard a selection

Maybe like this chart only approach?

Partner
Partner

Re: sales disregard a selection


thanks this looks good,

but I don't understand , if select custname isn't should show me the sales of all customers anyway ?

because the custname= in the set analysis in the expression.

dt

Partner
Partner

Re: sales disregard a selection

just nullify your customername in set expression

Employee
Employee

Re: sales disregard a selection

Use sum({$<custname=>}quant) as expression and tick 'supress zero values'

Employee
Employee

Re: sales disregard a selection

I think using =aggr(Only({$<custname=>} partname),partname) would simpler than your dimension too

Highlighted
Partner
Partner

Re: sales disregard a selection

In the expression if you use custname= you will get the sales for all Customers and its not the meaning... I need to see all the items even if the custname I select didn't Buy it Thanks Dt

Employee
Employee

Re: Re: sales disregard a selection

Hi Doron, in this case, you wanna see "0" for the product, right?

PFA and check if fits your needs

MVP
MVP

Re: sales disregard a selection

but I don't understand , if select custname isn't should show me the sales of all customers anyway ?

because the custname= in the set analysis in the expression.

I can't see custname= in your original expression. Or are you talking about the count in the calculated dimension?

I don't think this will work like you want. And using my approach, I think you don't need the calculated dimension, a simple partname as dimension field should be enough.