Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

houstonblock99
New Contributor

Sum totals where field = 'x'

PartLoad DateSegmentTotals
123456-1235/29/2017Total Forecast2800
123456-1235/29/2017Shipment500
123456-1235/29/2017Open Order100
123456-1236/29/2017Total Forecast5000
123456-1236/29/2017Shipment350
123456-1236/29/2017Open Order224

All,

I have learned a lot from reading the forums and finally decided to post after struggling to figure out what would allow me to do the following.  I am not working on anything specific but for my own self paced learning and wanted to understand how something could be done. In the example above I have multiple columns, one of which is segment.  In segment for each part the 3 key values are always populated (Total Forecast, Shipments, Open Orders). What I am looking to do is have a KPI that shows only the total forecast when a particular part and load date are selected.   I know I am missing something simple. I have several KPI's from other sources that I have working, however, they do not require a field filter to only look at one component.

The result I am looking for would be the KPI box and say I selected in my filter pane's the part and load date of 6/29, I would expect the KPI result to show 5000, if I unselected the data it would show the combined 7800.

I hope this makes sense.

Thanks

Houston

1 Solution

Accepted Solutions
aarkay29
Valued Contributor

Re: Sum totals where field = 'x'

may be this exp in text box

Sum({<Segment={"Total Forecast"}>}Totals)

2 Replies
aarkay29
Valued Contributor

Re: Sum totals where field = 'x'

may be this exp in text box

Sum({<Segment={"Total Forecast"}>}Totals)

houstonblock99
New Contributor

Re: Sum totals where field = 'x'

Thanks Aar for the quick response!

Community Browser