topic Re: Alternate States ? in QlikView

Alternate States ?

Mon, 17 Nov 2014 13:08:21 GMT

Hi All,

I have Year & Month Filters, Product Group & Region Filters are there in Dashboard...

I need to Keep a Limitation for For one Chart Where Year & Month Filter Should not WOrk...

Can any help me on this Urgent..

Regards,

Heather

Re: Alternate States ?

mdmukramali — Mon, 17 Nov 2014 13:09:47 GMT

Dear,

In set analysis use like

if Year and Month are in same State of Dashboard then use the expression like below.

=Sum( {<Year=,Month=>}Sales)

if Year and Month are in different state then no need to include them in the expression it will not effect on year and Month selections.

if you need something else you can share sample file so that we can help u.

Thanks,

Mukram

Re: Alternate States ?

ashfaq_haseeb — Mon, 17 Nov 2014 13:20:41 GMT

Hi,

use this expression where you want to omit filters

=Sum( {<Year=,Month=>}Sales)

Regards

ASHFAQ

Re: Alternate States ?

Mon, 17 Nov 2014 13:23:37 GMT

HI Ali,

It was a big Set Analysis Expression its not possible...

Can you tell Some option na..

Regards,

Heather

Re: Alternate States ?

mdmukramali — Mon, 17 Nov 2014 13:55:29 GMT

Dear,

In that set analysis include this

Year=,Month

Thanks.

Re: Re: Alternate States ?

Mon, 17 Nov 2014 14:01:34 GMT

HI Ali,

its not possible to include year & Month, That O/P is coming on Various Dates & Years ...

Please try to understand & give me an Exclude option for Year & Month filter for that Particular Chart....

please help me on this

Re: Re: Alternate States ?

ashfaq_haseeb — Mon, 17 Nov 2014 15:15:05 GMT

Hi post your expression here.

Re: Alternate States ?

Tue, 18 Nov 2014 04:47:27 GMT

Based Year & Month Filter it Should not change...

Sales:

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

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

sum(IF(YEAR(DN_TRAN_Dt) = Year('$(vMaxDt)') AND [DN Dr/Cr] = 'D' AND [DN CODE] LIKE '301*',[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(CJV_TRAN_Dt) = Year('$(vMaxDt)') AND [CJV Dr/Cr] = 'C' AND [CJV CODE] LIKE '301*',[CJV_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)') AND [CN Dr/Cr] = 'D' AND [CN CODE] LIKE '301*', [CN_Finance INR])) -

Sum(If(Year(CN_TRAN_Dt) = Year('$(vMaxDt)') AND [CN Dr/Cr] = 'C' AND [CN CODE] LIKE '301*', [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(CJV_TRAN_Dt) = Year('$(vMaxDt)') AND [CJV Dr/Cr] = 'D' AND [CJV CODE] LIKE '301*',[CJV_Finance INR]))+

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

Budget:

num(sum(if([Target Month] <= month('$(vMaxDt)') and [Target Year] = Year('$(vMaxDt)'), [Sales Target])),'#,##0')