Set analysis fields it chart table

Thu, 20 Feb 2014 14:49:06 GMT

Hi,

I'm have already solved some problems with the help of community hope this time you guys can help me as well.

I have a chart table with customers and their debts interval:

And i have a selection box where i can filter out the delay interval for customer. The filter box is a dimesion which I calculate during script load. The set expression formulas on chart box look like this:

This is the formula for 8-15 field:

=Sum({$<Year,Quarter,Month,Day,Fact = {">=$(=8)<=$(=15)"}>} Balance)

What i want to achieve is when i select any of the values from selection box which is a dimension delay the chart box should give me all results in a table where the selected field values are <>0 and another fields have any values can be zeros as well.

I will describe you what is wrong now:

For example i put a field delay to be ignored on a Not due fields so my not due set expression looks like this

=Sum({$<Year,Delay,Quarter,Month,Day,Fact = {"<$(=0)"}>} Balance)

And 8-15 fields

=Sum({$<Year,Delay,Quarter,Month,Day,Fact = {">=$(=8)<=$(=15)"}>} Balance)

Then i select the field from selection box 8-15 and the result is given all values from 8-15 including zero values and all values from not delay but i want to achieve is to output all values from 8-15 than are <>0 and any value from Not due.

The same situation has to be on any other selection or field.

To simplify if i select a field it has to return <>0 values on that field and other fields from chart table have to return the value what it has.

thanks

jja

Re: Set analysis fields it chart table

Fri, 21 Feb 2014 11:52:33 GMT

Please help to keep me going forward. It really sucks to be stuck:)

topic Re: Set analysis fields it chart table in QlikView

Set analysis fields it chart table

Re: Set analysis fields it chart table