topic Re: Calculated Dimension based in Another Dimension in QlikView

Calculated Dimension based in Another Dimension

Tue, 16 Jun 2015 19:41:09 GMT

Hello

I want to make a pivot chart that show me the sales of each store, but only I want to view the stores that have more than $ 800 in the last week based on today (no matter the filters I use on dates).

I try to make the next calculated dimension but the system give me an error:

=If(Sum({<FECHA = {">=$(=WeekStart(Date(Today()-7))) <=$(=WeekEnd(Date(Today()-7)))"}>} TOT_COMISION_COMPARTIDA) > 800, TOT_COMISION_COMPARTIDA)

Somebody have a better idea

Best Regards

Re: Calculated Dimension based in Another Dimension

sinanozdemir — Tue, 16 Jun 2015 19:49:22 GMT

Try to put it in an Aggr() function.

Hope this helps

Re: Calculated Dimension based in Another Dimension

Tue, 16 Jun 2015 19:50:20 GMT

Where I need to put it??

Re: Calculated Dimension based in Another Dimension

sinanozdemir — Tue, 16 Jun 2015 19:55:08 GMT

=If(Aggr(your function(), Dimension), Dimension).

Re: Calculated Dimension based in Another Dimension

Tue, 16 Jun 2015 20:17:02 GMT

It not send me an error, but not display me the stores, only leave in blank the dimension

Re: Calculated Dimension based in Another Dimension

sunny_talwar — Tue, 16 Jun 2015 20:29:51 GMT

Try this may be:

=If(Aggr(Sum({<FECHA = {">=$(=WeekStart(Date(Today()-7))) <=$(=WeekEnd(Date(Today()-7)))"}>} TOT_COMISION_COMPARTIDA), SomeSortofStoreID) > 800, TOT_COMISION_COMPARTIDA)

Re: Calculated Dimension based in Another Dimension

Tue, 16 Jun 2015 20:32:27 GMT

Nop is not working

Re: Calculated Dimension based in Another Dimension

sinanozdemir — Tue, 16 Jun 2015 20:33:42 GMT

Can you post a sample dataset if it is not confidential?

Thanks

Re: Calculated Dimension based in Another Dimension

MarcoWedel — Tue, 16 Jun 2015 22:45:49 GMT

Hi,

one solution could be:

hope this helps

regards

Marco