topic Re: Make an Independence to other fields in QlikView

Make an Independence to other fields

Anonymous — Mon, 23 May 2016 16:38:58 GMT

Hello,

I would like to setup an Independence for this field, because when i choose any field, this table disappears:

With the Date selection:

With an other selection:

How can i do that please ?

Sébastien.

sunny_talwar — Mon, 23 May 2016 16:40:37 GMT

If you want it only filter based on Date you can try this:

Sum({1<Date = $::Date>}Sales)

Assuming Sum(Sales) is your current expression

Or if you just want to ignore selections in PC, you can try this:

Sum({<PC>} Sales)

santiago_respane — Mon, 23 May 2016 16:43:27 GMT

Hi,

You can detach your table, or you can use set analysis to ignore the selections applied to that field.

Like this:

=SUM({<PC=>} YourFieldToBeAggregated)

Let me know if this helps.

Kind regards,