topic Re: group dropdowns in QlikView

group dropdowns

Tue, 23 Sep 2014 11:56:28 GMT

Hi All

i have dimension in chart called ' Shipped Status', which has following drop down lists

Shipped
Undershipped
Overshipped
WIP
Projection

So, in the Pivot table, I would like show in Shipped , undershipped and overshipped in one column and WIP ,Projection in another columns

Appreciate if you help me out on this

Jayanthan

Re: group dropdowns

ashfaq_haseeb — Tue, 23 Sep 2014 12:00:30 GMT

Hi,

Create two more dimensions as below

Dimension1

Shipped
Undershipped
Overshipped

Dimension2

WIP
Projection

Regards

ASHFAQ

Re: group dropdowns

richard_pearce6 — Tue, 23 Sep 2014 12:04:17 GMT

Not sure if I fully understand your question (perhaps an image of what you're trying to acheive will help)

You could use set anaylsis;

Column 1 exp: =Sum ( { <[Dimension Field={'Shipped',Unsershipped','Overshipped'} > } [Field to Sum])

Column 2 exp: =Sum ( { <[Dimension Field={'WIP','Projection'} > } [Field to Sum])

Richard

QlikCentral.com

Re: group dropdowns

Tue, 23 Sep 2014 12:19:32 GMT

Hi Jayanthan,

you should be able to do this with a single new grouping dimension, in your load script do something like the below and use the resulting dimension in your pivot chart.

If(Match([Shipped Status],'Shipped','Undershipped','Overshipped') ,'Shipped Group',[Shipped Status]) As [Shipped Grouping]

That will give you a new dimension with the 3 shipped status all under a new single value and all others (WIP, Projection) as their own value, so you should get the column layout you want with just a single expression

hope that helps

Joe