topic Re: selected value in data Island and dimensions in graph in QlikView

selected value in data Island and dimensions in graph

Mon, 22 Dec 2014 04:38:27 GMT

Hello,

The requirement is to filter on 2 facts based on single value selection.So I have used a list box to fill in data with data island.

I am grouping based on selected value in data island on a graph and using some triggers and set analysis in expressions.

When only 1 value is selected in data island, the graph is perfect.

But when multiple values are selected, it is summing up the result as below:

How to avoid this.

Thanks,

Deepa

Re: selected value in data Island and dimensions in graph

Mon, 22 Dec 2014 04:50:40 GMT

post your sample application for more clarification of your requirement.

Re: selected value in data Island and dimensions in graph

Mon, 22 Dec 2014 05:04:33 GMT

PFA the sample...

Re: selected value in data Island and dimensions in graph

SunilChauhan — Mon, 22 Dec 2014 05:25:00 GMT

ther is no link between date and TrackingHardCoating and TrackingQuantity

and inpace of sum you need to count for TrackingHardCoating , as these seems as ID's and sum(TrackingQuantity)

hope this helps

Re: selected value in data Island and dimensions in graph

Mon, 22 Dec 2014 05:32:47 GMT

Hi Sunil,

Thanks for the reply,

Since the idea is to consider TrackingHardCoating for blue part (launched) and TrackingBreakage for red part (rejected) part of the graph, I used data Island.

The linking is been done using triggers

on Selection of TEMPDATE, I am setting a variable and using that in Set Analysis expression.

and Infact, it is not always 'HardCoating', it can be any value in 'Processed Workshop'. The column changes accordingly, for this there is another trigger on selection of 'Processed Workshop' to set vOperation

Sum(TrackingQuanity) or count(TrackingID) both should give the same result.

Thanks,

Deepa V