Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

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

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.Untitled.pngswuehlhicstalwar1sreerangasane

1 Reply

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