topic Set analysis and selection in QlikView

Set analysis and selection

apoorvasd — Thu, 22 Mar 2018 05:34:35 GMT

Hello Everyone,

I have a chart in my QlikView application in which I am using set analysis in expressions to calculate the values based on set analysis conditions. One of the expressions is as follows:

Freight-out= sum({$<F1={"Freight-out"}>}Data)/sum({$<F1={"Net sales without tooling"}>}Data)

Similarly there are 8 other expressions in the stacked bar chart as shown in the below screenshot.

Field F1 here contains values, "Freight-out", "Freight-in", "Direct Labor", "Energy", "Act Scrap % of Revenue", "Costs of pers. overhead", "Other Overhead Costs", "Maintenance", "Depreciation" and "Net sales without tooling". User wants a stacked bar graph which displays Freight-out as Freight out value divided by Net sales without tooling value, Freight-in as Freight-in value divided by Net sales without tooling value and so on... To arrive at these calculations I have written the expression as shown above for Freight-out above. Similar expression applies for other F1 values as well. Now the problem is user wants to see only Freight-out data for all plants when he selects "Freight-out" in field F1. Similarly he would like to see only Freight-in data for all plants when he selects "Freight-in" in field F1 and so on...Since I have applied condition on field, F1 using set analysis, any selection made in this field isn't affecting the graph. Is it possible to do so in QlikView?

Any help on this?

Thank you.

Re: Set analysis and selection

tresB — Thu, 22 Mar 2018 05:52:05 GMT

Not sure if I understood right. Implicit Set Operators (perhaps '*') might be what you need.

Re: Set analysis and selection

apoorvasd — Thu, 22 Mar 2018 06:17:51 GMT

Hi Tresesco,

Thanks for your response. I will go through it!

Here is what I want, in case the above explanation was not so clear!

When I select value, "Freight-out" in field F1, the graph should display only Freight-out data for all plants. Similarly, if I select, "Freight-in", graph should display only Freight-in data for all plants and so on. Something like below!

Thank you.

Re: Set analysis and selection

tresB — Thu, 22 Mar 2018 06:49:20 GMT

Could you also attach your sample qvw?

Re: Set analysis and selection

apoorvasd — Thu, 22 Mar 2018 07:06:45 GMT

PFA the application! This application contains data only for two plants.

Thank you.

Re: Set analysis and selection

tresB — Thu, 22 Mar 2018 07:18:49 GMT

I guess, you need to use conditional enablement of the expression, and use expression like:

=MinString(F1='Freight-out')

I have shown for first two expressions in sample app, rest you can.

Re: Set analysis and selection

apoorvasd — Thu, 22 Mar 2018 08:14:49 GMT

Hi Tresesco,

Great! That works as expected. Thanks a lot!