topic Re: ExpressionGrouping in a chart?possible? in QlikView

ExpressionGrouping in a chart?possible?

Thu, 09 Jun 2011 12:52:22 GMT

Hi Guys,

I have a chart with Dimension grouping(Material, Customer, Plant etc) and there are expressions likes sum(OrderquantityinPieces), Sum(DeliveryQuantityinPieces), Sum(DeliveryQuantityinPieces/OrderquantityinPieces), Sum(OrderquantityinCarton),Sum(DeliveryQuantityinCarton),Sum(DeliveryQuantityinCarton/OrderquantityinCarton), Sum(OrderquantityinPallet),Sum(DeliveryQuantityinPallet),Sum(DeliveryQuantityinPallet/OrderquantityinPallet)

This looks BigTable and I want to make it Dynamic where I can select the Data based on pallet, Carton, Pieces.

I also dont want to make individual charts with Cartons, Pallets, Pieces.

Just Like I made Dimension as a cycleGroup to select the data, I want the expressions also to be dynamic and thereby reduce this bigtable to small 3 expressions like Sum(Orderquantity), Sum(DeliveryQuantity), Sum(DeliveryQuantity/Orderquantity)

Any Ideas how to make this one simple?

Thanks

Sravan

ExpressionGrouping in a chart?possible?

pat_agen — Thu, 09 Jun 2011 13:29:51 GMT

hi,

create a variable called vUoM for example (for Units of measure). Put it in an input box with a constraint so that it can take the value 'Carton', 'Pieces' or 'Pallet'. Always have one selected value.

have three expressions in your chart like this:

sum(Orderquantityin$(vUoM))

sum(Deliveryquantityin$(vUoM))

sum(Orderquantityin$(vUoM))/Deliveryquantityin$(vUoM))

try it and see.

Re: ExpressionGrouping in a chart?possible?

Thu, 09 Jun 2011 15:10:40 GMT

Hi Pat,

correct me if I am wrong. For this solution to work after giving the value in the Inputbox, script must be reloaded to get the data. The users logging in through the accesspoint cannot do it. Hence it is not useful.

Thanks for your answer.

Regards

Sravan

Re: ExpressionGrouping in a chart?possible?

pat_agen — Thu, 09 Jun 2011 15:55:06 GMT

Hi Sravan,

It should work fine. No reload needed. It's simply $() expansion at work. The $(vUoM) will be replaced with one of the literals Pallets, pieces or cartons. The expression will read as sum(OrderquantityinPallets) for example. No reload needed.

try it

regards.

Re: ExpressionGrouping in a chart?possible?

Fri, 10 Jun 2011 09:16:09 GMT

Hi Pat,

After implementing this, the application does work fine but after sometime whenever I am saving, it does not react and I have to close the application thru the Taskmanager and open again. It is performance wise not good.

Regards

sravan

ExpressionGrouping in a chart?possible?

pat_agen — Fri, 10 Jun 2011 09:27:59 GMT

Hi Sravan,

I am surprised because it should just work as normal expressions. Could you post your qvw perhaps with some sample/scrambled data?

Re: ExpressionGrouping in a chart?possible?

jagannalla — Fri, 10 Jun 2011 10:03:02 GMT

Hi Pat,

I just went through your procudure really it is good. But when i'm trying to do dis it displying the error in expression as you can see in enclosed image.

Re: ExpressionGrouping in a chart?possible?

Fri, 10 Jun 2011 10:06:47 GMT

Hi Jagan,

Does your fieldname is OrderQuantity$(vData) ?

I mean if you defined the Variable vData as KAR then the field must be same as OrderQuantityKAR. Then only it will work.

Hope that helps

Sravan

Re: ExpressionGrouping in a chart?possible?

jagannalla — Fri, 10 Jun 2011 10:12:51 GMT

Sravan ya it is same as KAR...

If it is working in your application because when i tried in expression like sum(OrderQuantityKAR). It is working if i tried my using input variable it's not working i.e sum(OrderQuantity$(vData))

Re: ExpressionGrouping in a chart?possible?

jagannalla — Fri, 10 Jun 2011 10:16:40 GMT

Ya it's working... in mistake i added single quote ( ' ).