topic Range of Values in QlikView

Range of Values

Wed, 02 Feb 2011 17:55:00 GMT

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.

Range of Values

deepakk — Thu, 03 Feb 2011 05:19:45 GMT

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.

Range of Values

Fri, 04 Feb 2011 00:21:31 GMT

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

Range of Values

Fri, 04 Feb 2011 00:28:55 GMT

Thanks.

What should i put in the fiel to sum?

Range of Values

Fri, 04 Feb 2011 00:33:29 GMT

Hi,

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

Thanks

Nick

Range of Values

Sat, 05 Feb 2011 18:21:07 GMT

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

Range of Values

Mon, 07 Feb 2011 14:02:41 GMT

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