Set analysis prob

[nikhilgarg]

Hey,

I want to use 2 different states in my expression. My scenario is:

Year : Inherited State

Month : Inherited State

GLDesc : State1

I have line chart with exp:

a:  Sum({State1<KPI = {'MktExpse'}>}Value) as Expenses

b:  Sum(Value1) as Sales

Now when i select any year or month, Expenses does not change untill i select any value from GLDesc.

I want Expenses expression to change for Year and Month Selection as well.

Thanks,

Nikhil

[PrashantSangle]

Hi,

try without using State1 in your expression.

Regards

[PradeepReddy]

try something like this...

Sum({State1<KPI = {'MktExpse'},Year=$::Year,Month=$::Month>}Value)

[nikhilgarg]

Hey,

If i dont use State1 then i will not be able to bifurcate expenses GLDesc wise. I have to use State1.

Can i use another state as well in same expression for Year and Month?

[nikhilgarg]

Hey,

This is also not working

On 06-Jan-2016 12:26 PM, "pradeep taniparthy" <qcwebmaster@qlikview.com>

[Kushal_Chawda]

try this

Sum({State1*$<KPI = {'MktExpse'},Year=$::Year,Month=$::Month>}Value)

[MayilVahanan]

Hi

Try like this

Sum({State1<KPI = {'MktExpse'},Year=$::Year,Month=$::Month>}Value)

Edit: Can you able to post the sample.. The above expression works fine for me.

[#8]

Hi Nikhil,

This approach should give you what you looking for

sum({State1<KPI={'Exp'},Year={$(=concat(DISTINCT chr(39) & Year & chr(39),',') )},Month={$(=concat(DISTINCT chr(39) & Month & chr(39),',') )}>}Value)

[#9]

MayilVahanan‌

Please talk me through your approach. I have never seen this before and this is quite a brilliant way to achieve the desired output.

Thanks,

Byron

[MayilVahanan]

Hi Bryon,

This is the  general syntax for include the default state in our expression.

Please refer the attached document.. Or I will upload the sample qv document soon.