topic Re: Ignoring selections for chart dimension in QlikView

Ignoring selections for chart dimension

Fri, 06 May 2016 10:17:50 GMT

Hi,

I'm trying to ignore any selection given for TransactionWeek in a chart.

In the expression I have used: sum({$<TransactionWeek= >} LegFare) but doesn't seem to work.

Can anyone help?

sunny_talwar — Fri, 06 May 2016 15:41:30 GMT

There is a hidden field in your data base called _LYDate which you also need to ignore because there is selection made in that field as well

Sum({$<TransactionWeek=, _LYDate>} LegFare)

Is this not working?

MarcoWedel — Fri, 06 May 2016 21:20:52 GMT

did you practise divination lately or how comes you knew?

regards

Marco

sunny_talwar — Fri, 06 May 2016 21:23:47 GMT

Marco -

I have been learning some woo-doo lately... Just tried to check if it worked today.

trdandamudi — Fri, 06 May 2016 22:39:59 GMT

Sunny,

I had the same question like Marco, now I know the answer...

Tue, 10 May 2016 13:31:40 GMT

Hi,

Great this working for TY.

This year is working:

=sum({$<TransactionWeek=, _LYDTE >} LegFare)

But Last Year is still not working:=sum({$<TransactionWeek= ,_LYDTE, TransactionDate = altDAY::TransactionDate, _LYDAY, TransactionYear>}LegFare)

Any ideas?

Thu, 12 May 2016 10:20:59 GMT

=Sum({$<TransactionWeek= ,_LYDAY, TransactionYear = p({altDAY<TransactionWeek, _LYDAY>})>}LegFare)

sampada0810 — Wed, 22 Jun 2016 12:09:02 GMT

You can use set analysis to ignore the dimensions

for eg.

Sum({$<Region=>}Sales)

This will return the current selections value ignoring the region selection