topic Re: Few Issues (Front end side ) in QlikView

Few Issues (Front end side )

Wed, 01 Jul 2015 18:20:52 GMT

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‌

Re: Few Issues (Front end side )

Anonymous — Wed, 01 Jul 2015 18:35:23 GMT

Hi,

for 2)

num(($(vCountCusMaxYear)-$(vCountCusPreYear))/$(vCountCusPreYear)*100, '#.##0,00 %')

Elena

Re: Few Issues (Front end side )

Anonymous — Wed, 01 Jul 2015 18:41:58 GMT

for 1)

goto sheet properties, tab Settings and define custom Color and tab color

then define calculated color

=if (GetActiveSheetId()='Document\SH01',rgb(255,0,0),rgb(0,0,255))

you can use other Colors as rgb code or define variable which hold rgb code

also check the Name of SheetId

Re: Few Issues (Front end side )

Qrishna — Wed, 01 Jul 2015 18:58:02 GMT

1. Rt Click on tab --> Sheet properties --> Check 'Custom Colors' --> Tab Color -->Calculated -->

put the expression =If(Subfield(GetActiveSheetId(),'\',2) = 'Sheet ID' ,Green(),White())

vCountMaxCusYear= num(($(vCountCusMaxYear)-$(vCountCusPreYear))/$(vCountCusPreYear)*100, '#.##0,00 %')

vCountPreCusYear=num(Count({<Year={$(vPreYear)}>} DISTINCT CustomerName)), '#.##0,00 %')

Button :

= '[ % Change in Customer Count : '&

num(((vCountCusMaxYear-vCountCusPreYear)/vCountCusPreYear)*100&'% ]','#.##0,00% ')

3. enclose the value in single quotes. see below screenshot.

4. where do you want to use the expression Sales = unit Price * Qty?

in a list box? in chart as dimension or as expression or where else?

Re: Few Issues (Front end side )

marcus_sommer — Wed, 01 Jul 2015 19:04:37 GMT

It's not really helpful to ask several questions in one posting, see here what you could do to get the best results from the community:

Qlik Community Tip: Best Practices for Discussi... | Qlik Community

Usage Guidelines for Qlik Community

Further thoughts on Qlik Community Guidelines

QlikCommunity Tip: How to get answers to your post?

Its not about the answer, rather it’s about the question…

Adding and Replying to Discussions

QlikCommunity Tip: Add Code to your Content

Preparing examples for Upload - Reduction and Data Scrambling

Nevertheless here some answers:

1. put an expression like this in color-option for the sheet-tab

=if(GetActiveSheetId() = 'Document\SH08', red(), white())

3. You could use options within the object-properties in tab visualizations or an attribut-expressions to the column

--> click on plus-sign by dimensions/expressions --> choose your attribut --> enten an expression like

if(sum(value) >= 0.2, red(), green())

4. You should do such a calculation within the load-script if you want access to them as field

5. Here are some examples for advanced calculations regarding to the compare of periods

How to use - Master-Calendar and Date-Values

- Marcus

Re: Few Issues (Front end side )

Wed, 01 Jul 2015 19:08:06 GMT

Sales as Dimension in statistics Box....

But i dont have Dimension Sales...what i have are UnitPrice and Quantity

Re: Few Issues (Front end side )

Wed, 01 Jul 2015 19:25:34 GMT

Thanks alot friends..

Re: Few Issues (Front end side )

Wed, 01 Jul 2015 21:18:24 GMT

Can you check this issue please...

Why i am getting same values for Margin columns??

This is Net SAlES

This is COST

But I am getting same Values for all Countries...Why i dont know..

I defined Margin: NetSales-Cost

Can Some one help Me please..

Thanks

Venkat

Re: Few Issues (Front end side )

Qrishna — Wed, 01 Jul 2015 21:22:42 GMT

You have to aggregate with respect to country.

Re: Few Issues (Front end side )

Wed, 01 Jul 2015 21:34:49 GMT

Can you clearly Explain please ..!!

Re: Few Issues (Front end side )

Qrishna — Wed, 01 Jul 2015 21:37:32 GMT

what are your dimensions and expressions.

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

Thanks

Re: Few Issues (Front end side )

Wed, 01 Jul 2015 21:44:47 GMT

How can i attach QvW file?

Sorry i am new to qlikview and community?

Re: Few Issues (Front end side )

Qrishna — Wed, 01 Jul 2015 21:46:27 GMT

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

Re: Few Issues (Front end side )

Wed, 01 Jul 2015 22:51:21 GMT

I dont have such Option bro