topic Re: Ignore dimension is not working in QlikView

Ignore dimension is not working

Sun, 24 Nov 2013 23:55:17 GMT

I have a dimension and a few expressions. I want the second expression to be independant of the dimension.

I tried.

Sum({<Dimesnion1=>} measure), but doesn't seem to work at all. My intention is even if the dimension evaluates to NULL, the expression should still yield results.

Thanks,

Ram

Re: Ignore dimension is not working

Sokkorn — Mon, 25 Nov 2013 01:29:12 GMT

Hi Ram,

Can you tell me how many dimension and expression in your chart? and what is your expression definition?

Regards,

Sokkorn

Re: Ignore dimension is not working

Mon, 25 Nov 2013 01:34:43 GMT

Hi Sokkorn, I have got 2 dimensions and a number of expressions. This particular expression which I want to exclude dimension1 is as follows.

=Sum({<WEEK_445_TXT=>}total<[Product Attributes]>[Stock Book Qty])

Re: Ignore dimension is not working

Sokkorn — Mon, 25 Nov 2013 01:42:20 GMT

Hi Ram,

Your expression look like ok. Can you share your app? You can scrambling your data via this doc

Regards,

Sokkorn

Re: Ignore dimension is not working

jagan — Mon, 25 Nov 2013 02:07:56 GMT

Hi,

Can you attach some sample data and come up with an example, it would be easier to understand and give the solution.

Regards,

Jagan.

Re: Re: Ignore dimension is not working

Mon, 25 Nov 2013 02:33:55 GMT

Hi, Attaching the document. I want the pivot table to display units as 11 and not -45. (Similar to the chart on the right).

Re: Ignore dimension is not working

er_mohit — Mon, 25 Nov 2013 05:16:20 GMT

Try this

sum(Aggr(NODISTINCT sum(TOTAL [Stock Book Qty]),WEEK_445_TXT))

Re: Ignore dimension is not working

Mon, 25 Nov 2013 22:17:29 GMT

Hi Mohit, Thanks for that. It seemed to work at the first sight, but once I clear the selection it gave undesirable results.

I tried this expression.

sum({<AsOf445Year=,YEAR_445=,MONTH_445_TXT=,WEEK_445_TXT=,DAY_445=>}Aggr(sum({<AsOf445Year=,YEAR_445=,MONTH_445_TXT=,WEEK_445_TXT=,DAY_445=>} [Stock Book Qty]),WEEK_445_TXT,[Product Attributes]))

But of no use.

Re: Re: Ignore dimension is not working

Mon, 25 Nov 2013 22:21:40 GMT

You can see once I clear the store selection it gives an extraordinary number for Owen. I have attached the qvw again with your expression and the store selection cleared.