topic Re: high light ? in QlikView

high light ?

Thu, 06 Nov 2014 09:36:32 GMT

Hi All,

I have created some charts in a tab..but I need not to be high lighted one YTD Chart on Selection of any filter like year & month..

it should be constant it should be updated to current year to till date..

can any one help me on this..

Regards,

Kacy

Re: high light ?

Anonymous — Thu, 06 Nov 2014 09:45:15 GMT

Hi,

If you are using set analysis, you may exclude those selections by adding them with "=" in the set analysis. Something like below,

Sum({<year=, month=>} AMOUNT)

Re: high light ?

Anonymous — Thu, 06 Nov 2014 09:48:54 GMT

Heather,

You can add a Conditional expression in those charts you want to hide if any selection. For instance:

=if(GetPossibleCount(YearField)=Count({1} DISTINCT YearField) and GetPossibleCount(MonthField)=Count({1} DISTINCT MonthField), 1,0)

Marc.

Re: high light ?

MayilVahanan — Thu, 06 Nov 2014 09:49:56 GMT

Try like this

=Sum({1}Sales) - ignore all selections

Sum({<Year=, Month=>} Sales) - ignore Year and Month Selection alone.

Hope it helps

Re: high light ?

Thu, 06 Nov 2014 10:12:06 GMT

Not working Marc..

This my EXpr in Gauge chart...

((Sum(If([Invoice Year] = Year('$(vMaxDt)'),[Invoice Turn Over]))+

(sum(IF(YEAR(DN_TRAN_Dt) = Year('$(vMaxDt)') AND [DN Dr/Cr] = 'C' ,[DN_Finance INR]))-

sum(IF(YEAR(DN_TRAN_Dt) = Year('$(vMaxDt)') AND [DN Dr/Cr] = 'D' ,[DN_Finance INR])))+

sum(IF(YEAR(JV_TRAN_Dt) = Year('$(vMaxDt)') AND [JV Dr/Cr] = 'C' AND [JV CODE] LIKE '301*',[JV_Finance INR]))+

sum(IF(YEAR(RJV_TRAN_Dt) = Year('$(vMaxDt)') AND [RJV Dr/Cr] = 'C' AND [RJV CODE] LIKE '301*',[RJV_Finance INR])))-

(Sum(If(Year(CN_TRAN_Dt) = Year('$(vMaxDt)'),[CN_Finance INR]))+

sum(IF(YEAR(JV_TRAN_Dt) = Year('$(vMaxDt)') AND [JV Dr/Cr] = 'D' AND [JV CODE] LIKE '301*',[JV_Finance INR]))+

sum(IF(YEAR(RJV_TRAN_Dt) = Year('$(vMaxDt)') AND [RJV Dr/Cr] = 'D' AND [RJV CODE] LIKE '301*',[RJV_Finance INR]))))

Re: high light ?

ashfaq_haseeb — Thu, 06 Nov 2014 10:22:50 GMT

If you don't want selection to effect.

Then simply try this

=Sum({1}Sales)

Alter your expression accordingly.

Regards

ASHFAQ

Re: high light ?

Anonymous — Thu, 06 Nov 2014 10:26:02 GMT

Heather,

I recommend to use set analysis instead of the IF clauses, like:

=Sum({<[Invoice Year] ={"$(=Year('$(vMaxDt)'))">} [Invoice Turn Over]) +Sum(...) -Sum(...)...

If you want to make it constant for any MOnth selection, just add [YourMonthField]= , like:

=Sum({<[Invoice Year] ={"$(=Year('$(vMaxDt)'))", [YourMonthField]=>} [Invoice Turn Over]) +Sum(...) -Sum(...)...

I am not sure if you require also to show/hide a chart if any selections. In case you have to, use the expression I gave you before in the conditional expression in Design tab of the object.

Hope it helps.

Marc.

Re: high light ?

Thu, 06 Nov 2014 11:51:26 GMT

but in that expression Like operator also is there, how to convert that into set analysis..

convert for above one, please let me know..

Re: high light ?

Anonymous — Thu, 06 Nov 2014 11:53:54 GMT

add this in set analysis:

[JV CODE]={"301*"}

Marc.

Re: high light ?

ashfaq_haseeb — Thu, 06 Nov 2014 11:55:18 GMT

Like this

[JV CODE] ={ '301*'}

Regards

ASHFAQ

Re: high light ?

Thu, 06 Nov 2014 12:06:22 GMT

I am getting Error ..

Please Convert this 2 lines So that I will convert accordingly,

sum(IF(YEAR(DN_TRAN_Dt) = Year('$(vMaxDt)') AND [DN Dr/Cr] = 'D' ,[DN_Finance INR])))+

sum(IF(YEAR(JV_TRAN_Dt) = Year('$(vMaxDt)') AND [JV Dr/Cr] = 'C' AND [JV CODE] LIKE '301*',

Re: high light ?

Anonymous — Thu, 06 Nov 2014 12:29:58 GMT

Heather,

You first have to create a field containing the YEAR(DN_TRAN_Dt) in your script code, let's name it [DN_TRAN_Dt Year] . And the same for JV_TRAN_Dt. Once it done, the expression will be:

=Sum({<[DN_TRAN_Dt Year] ={"$(=Year('$(vMaxDt)'))", [DN Dr/Cr] ={'D'}>} [DN_Finance INR])

+Sum({<[JV_TRAN_Dt Year] ={"$(=Year('$(vMaxDt)'))", [DN Dr/Cr] ={'C'}, [JV CODE]={"301*"}>} [DN_Finance INR])

I recommend you this: Set Analysis

Hope it helps.

Marc.