topic Re: Ignore Dimensions in QlikView

Ignore Dimensions

ajithsachin — Fri, 13 Feb 2015 09:58:05 GMT

Hi All,

I have a table like this.

now i need to show one straight table like

How to add the last column Ware house stock.

Can anybody help please.

Regards,

Ajith

Re: Ignore Dimensions

alexandros17 — Fri, 13 Feb 2015 10:07:17 GMT

in the dimension write at the place of Branch:

If(Branch='WhareHouse', Null(), Branch) then check the box "Suppress Null Values"

in the expressions write a new one:

Sum({$ <Branch = {'WhareHouse'}>} TOTAL [Current Stock])

let me know

Re: Ignore Dimensions

ajithsachin — Fri, 13 Feb 2015 10:17:41 GMT

Hi Alessandro Saccone,

Thanks for the reply.

This will work fine if only one item is there. My case i have multiple items. So i will get same stock fro all the items.

i need item wise ware house stock.

Regards,

Ajith

Re: Ignore Dimensions

PrashantSangle — Fri, 13 Feb 2015 10:19:55 GMT

Hi,

Try like

Use CalculatedDimension

if(not wildmatch(Branch,'WareHouse'),Branch)

then check supress Null Values

And Use two expression

1->sum(Current Stock)

2->Sum({<Branch="WareHouse">}Total Current Stock)

Regards

Re: Ignore Dimensions

Fri, 13 Feb 2015 10:22:25 GMT

Hi Ajith,

Please find the attachment.

Warm Regards,

Joshmi

Re: Ignore Dimensions

ajithsachin — Fri, 13 Feb 2015 10:22:32 GMT

Hi Max Dreamer,

Thanks.

This will work only if there is one item.

In case of multiple items this wont work.

Regards,

Ajith

Re: Ignore Dimensions

ajithsachin — Fri, 13 Feb 2015 10:28:19 GMT

Hi All,

Let me put my question in this way.

My table contains data like this.

and need result like this

I think now the question is clear.

Regards,

Ajith

Re: Ignore Dimensions

manojkulkarni — Fri, 13 Feb 2015 10:40:47 GMT

for warehouse, use aggr() on item, so it would return expected result.

Re: Ignore Dimensions

ajithsachin — Fri, 13 Feb 2015 10:47:26 GMT

Hi Manoj,

If you don't mind can you just add that expression and give.