Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ashokpaladugula
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
adamdavi3s
Master
Master

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