Range of Values

[#1]

Hey,

I have a database with columns A, B and C.

Column A is year, Column C is expenses, and B is the name of the expenses;

Im making a chart with sum ( {$<year=[2011]>} expense)/ sum ( {$<year=[2010]>} expense) -1 .

Now if only want to see the values of variation higher than a value that i will select in a variable, how can i do it?

I made a variable that i called Variation and then tried in the dimension to make this: if ( (sum ( {$<year=[2011]>} expense)/ sum ( {$<year=[2010]>} expense) -1)>Variation/100, Dimension that i select, null () )

It gives me an error.

[deepakk]

hi,

Use the same code in Expression .It will work

if ( (sum ( {$<year=[2011]>} expense)/ sum ( {$<year=[2010]>} expense) -1)>Variation/100,

(sum ( {$<year=[2011]>} expense)/ sum ( {$<year=[2010]>} expense) -1)

)

In the above code we are replacing the dimension with the expression.

[#3]

Hi,

Try using Set Analysis, similar to the example below

=Sum({$<DimensionToSelect={"=Sum({$<year=[2011]>}expense)/Sum({$<year=[2010]>}expense)-1)>$(Variation)/100"}>}FieldToSum)

You may need to adjust this sightly and you will need to specify the 'DimensionToSelect' and the 'FieldToSum'.

This should filter the list of values in 'DimensionToSelect' to only those where you're expression is greater than Variation/100

I hope this helps.

Thanks

Nick

[#4]

Thanks.

What should i put in the fiel to sum?

[#5]

Hi,

The 'FieldToSum' should be the value you would like plotted in your chart. Perhaps 'expense'?

Thanks

Nick

[#6]

Thanks for your help.

Perhaps u can help me in something more easier, i hope.

i'm making a few reports in qlikview and i'm debating with a problem of formatting colors and appearance in Lists and Multiple Selection boxes:

I don't how where to change the colors of the text inside a List:

In a multiple selection, if u pre-select the grade style, where do we change de position of the text in the first column, the colors of the respectivo text and tab.

These problems that im having in all the docs that im doing gives no chance to completely format the tex with the same color.

The problem in the multiple selection box its still critical because and can not change the formating of the text in the first columm.

Can u help me?

Best regards,

Eliano Marques

[#7]

Hi Eliano,

You can change the colour of text in a listbox but the process is quite long. You need to create a theme based on your listbox and then manually edit the TextColor>PrimaryCol>Col properties of theme (using notepad or an xml editor). Once you have done this you need to re-apply the theme and change the 'Selection Style Override' property on the Presentation tab of the listbox to be one of the following - 'Windows Checkboxes', 'Corner Tag', 'LED', 'LED Checkboxes'. Unfortunately this will not work with the 'QlikView Classic' style.

I think the same applies to a multi box but I'm not sure if you can change the text alignment for multi-box labels.

I hope this helps.

Thanks

Nick