topic Re: Ignoring value based on selection in QlikView

Ignoring value based on selection

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Ignoring value based on selection

sunny_talwar — Wed, 06 Apr 2016 12:29:52 GMT

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)

Re: Ignoring value based on selection

Chanty4u — Wed, 06 Apr 2016 12:30:00 GMT

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

Re: how to ignore selection on particular field value

Re: Ignoring value based on selection

sivarajs — Wed, 06 Apr 2016 12:30:20 GMT

sum({<Product>} sales)

Re: Ignoring value based on selection

Anonymous — Wed, 06 Apr 2016 12:44:35 GMT

Thanks for sharing information Chanty.

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

Re: Ignoring value based on selection

Anonymous — Wed, 06 Apr 2016 12:47:42 GMT

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