Multiple dimensions and multiple expressions has grouped chart with working of filters.

ashokpaladugula — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

we want show the grouped chart with multiple dimensions and multiple expressions and filters should apply.

Here am attaching the example. Please go through it.swuehl‌hic‌stalwar1‌sreerangasane‌

Re: Multiple dimensions and multiple expressions has grouped chart with working of filters.

adamdavi3s — Thu, 09 Feb 2017 09:06:26 GMT

I would create a dimension which is a valuelist based on a concat of your DelHours field, then us the same valuelist in a pick(match( expression, that should give you what you want.

Dimension will be something like =valuelist(concat(chr(39)&DelHours&chr(39),','))

Expression will be something like: pick(match(valuelist(concat(chr(39)&DelHours&chr(39),',')),'6hrs','4hrs','2hrs'),Sum({<DeliveryHours ={"<=6"}>} [Shipment Count] ) / Sum([Shipment Count]),Sum({<DeliveryHours ={"<=4"}>} [Shipment Count] ) / Sum([Shipment Count]),Sum({<DeliveryHours ={"<=2"}, DelHours=>} [Shipment Count] ) / Sum({1}[Shipment Count]))

Sorry haven't time to sort the exact syntax but that should be close ish

topic Multiple dimensions and multiple expressions has grouped chart with working of filters. in QlikView

Multiple dimensions and multiple expressions has grouped chart with working of filters.

Re: Multiple dimensions and multiple expressions has grouped chart with working of filters.