topic Re: Straight Table Requirement in QlikView

Straight Table Requirement

bohravanraj — Sun, 18 Jan 2015 14:15:46 GMT

Dear Folk,

I need help from you guys to get this Straight table where i have a Requirement from User For Straight Table / PIVOT Where he need Following Straight table:

Plant 2000

Plant- 2010

Plant - 2030

Plant - 2070

PLANT

PURCHASING GROUP

MATERIAL

DESCRIPTION

STOCK IN PLANT

STOCK VALUE

Value

Qty

NOM

Value

Qty

NOM

Value

Qty

NOM

Value

Qty

NOM

where in the above table the Yellow Color Cell is details For Selected Plant and Blue Color Cell are Information of Another Plant where Material From Selected Plant is available.

Thanks,

Vanraj

Re: Straight Table Requirement

Sun, 18 Jan 2015 14:53:40 GMT

Hey,

Couldn't understand you question. But if it's something related to colour,you can go through.http://community.qlik.com/message/327027#327027

Re: Straight Table Requirement

bohravanraj — Sun, 18 Jan 2015 15:24:59 GMT

Dear Navdeep,

I dont Want Color Combination(i had just Colored it for Understanding) but i want My Straight Table Report in Same Format.

For Example if i Had Selected Plant 2000, Then it should first show all detail Material Code wise for Plant 2000 and then It should show the Valuefor Same Material which are also Available iin Different Plant.

Thanx

Re: Straight Table Requirement

Anonymous — Sun, 18 Jan 2015 16:04:54 GMT

Hi,

you should use set Analysis for that purpose.

In the blue you Need to use

sum({<Plant={'Plant-2010}>}Value)

Please modfiy to your naming. Force the Dimension plant to your selection

Re: Straight Table Requirement

bohravanraj — Mon, 19 Jan 2015 05:52:42 GMT

Dear Rudlof,

if i use Set analysis then it shows material of both the Plant Selected as Well as Which is Mention in Set analysis,

But i here req. is we want to show all the material from Selected plant and only that much Material from Other Plant which are there in Selected Plant.

PFA EXAMPLE of QVW

Thanx

Re: Straight Table Requirement

preminqlik — Thu, 22 Jan 2015 13:16:12 GMT

hi there,

find attachment

Re: Straight Table Requirement

Anonymous — Mon, 26 Jan 2015 18:40:03 GMT

Hi Vanraj,

This is not the efficient way but it will solve your problem.

Cheers..!!

Re: Straight Table Requirement

Wed, 28 Jan 2015 10:26:30 GMT

Hey Vanraj,

Try this, Hope it helps