Few Issues (Front end side )

[#1]

Hello Friends,

I have few issues facing while creating a Dashboard... Can someone help me out in Learning New things in Qlikview..!!

1) I need to change  Sheet tab color when i navigate to next sheet...

What i mean is when i am in DashBoard Tab color should be in Green and other sheets tab color should be in white...similarly when i navigate to Details sheet.. Details sheet tab color should be Green and remaining Sheet tab colors should be in white..

2)How to give Number Format for a variable..??

I created a variables

vCountMaxCusYear=(Count({<Year={$(vMaxYear)}>} DISTINCT CustomerName))

vCountPreCusYear=(Count({<Year={$(vPreYear)}>} DISTINCT CustomerName))

And Created A Button with Text :

= '[ % Change in Customer Count : '&((vCountCusMaxYear-vCountCusPreYear)/vCountCusPreYear)*100&'% ]'

Output is

Here Value is -14.102564102564

I need.. it should be as -14.10 (its shouls be only 2 decimals)

How to changenumber format for Variable..

3)How to assign Numeric value in "Visual Cues" (Upper Value>=) but not Variable

4)Can i use different columns for different Metric (i.e.. Sum, Max, Min..) in Statistics Box

5)I have Date from jan-2009 to July- 2011..

For my Sales Corp Sheet...By default it should select July-2011... and should compare data from Jan to july for 2011 and 2010 years....

when i select 2010 it should compare data from Jan-Dec for 2010 and 2009 years...

I will be very ThankFull if someone help me please

Thanks

Venkat

sunindia‌ mov‌ alk‌ danieloberbillig‌ swuehl‌ maxgro‌ hic‌

[Qrishna]

what are your dimensions and expressions.

Could you please list them accordinlgy.   or attach the qvw.

Thanks

[#3]

How can i attach QvW file?

Sorry i am new to qlikview and community?

[Qrishna]

Hit Reply--> On top you find  'Use Advance Editor' -->Click Use Advance Editor' -->At the bottom you find 'Attach'

[#5]

I dont have such Option bro