Ignoring value based on selection

[Anonymous]

Hi,

I have a chart and in that two dimensions customer and product are there and expression is there.

If I made selection on customer it should reflect the chart. If i made selection on product it should reflect.

Pls suggest me how to achieve this

Regards,

Kumar

[sunny_talwar]

I think by default if you don't have any set analysis restricting selection in any particular field, QlikView will filter out whatever is out of selection. In case you are looking for a way to not allow QlikView to filter out based on selection in those two fields, you can try this:

Sum({<customer, product>}Sales) -> assuming your expression is Sum(Sales)

[Chanty4u]

1. sum({1<[Field]={'Value1','value23'}>} dim) 

Re: how to ignore selection on particular field value

[sivarajs]

sum({<Product>} sales)

[Anonymous]

Thanks for sharing information Chanty.

In this set analysis what is dim. Can you explain.

[Anonymous]

And one more thing here you are giving values manually. It should be dynamic.