QlikView App Dev

[kunkumnaveen]

Hello All,

i Need help in doing a condition enabling in a chart , in below combo chart by default i have to show as below

Dimension: YEARMONTH

Expression: 1)Prod:    Sum({<Month,Year,Date={">=$(=date(monthstart(addmonths(max(Date),-5)),'DD-MM-YYYY'))<=$(=date(((max(Date))),'DD-MM-YYYY'))"}>}p_input)

                        2)Sale:      Sum({<Month,Year,Date={">=$(=date(monthstart(addmonths(max(Date),-5)),'DD-MM-YYYY'))<=$(=date(((max(Date))),'DD-MM-YYYY'))"}>}p_d_op)

Combo:  

so far so good,

Now my requirement is to do a condition enabling , I have created a inline field called Category which as values prod,sale,Brand and in each expression i have added condition as shown below

Combo Chart:

Dimension: YEARMONTH

EXpression :1)   if(Getselectedcount(Category) =0 or Category='prod',

Sum({<Month,Year,Date={">=$(=date(monthstart(addmonths(max(Date),-5)),'DD-MM-YYYY'))<=$(=date(((max(Date))),'DD-MM-YYYY'))"}>}p_input)

)

Before selecting Category 

After selecting  prod from category

I am getting only Selected Year, Month prod values even after ignoring Year,Month

Kindly suggest,how to write condition in expression.

Thanks

[Lisa_P]

What are you expecting to see?

You are filtering on Category='prod', the chart is showing the MonthYear when 'prod' is sold

[kunkumnaveen]

Hello,

Yes ur right i am filtering on Category='prod ' and the chart is showing only prod bar,

the issue is, it is showing only 2019Dec bar where as it suppose to show last six months bars i mean 

from 2019Dec to 2019 jul,

Even though the current selections are Year =2019 and Month=Dec, But i have bypass those selections in my expression to show last six months bars.

[kunkumnaveen]

Any suggestion on how to write condition in expression plz

[kunkumnaveen]

Hello All , Kindly suggest on the above requirement plz

[nelsei1n]

Designer has built-in operators that can be used in enabling conditions or validations UPSers.

[kunkumnaveen]

HI, what exactly u mean to say, what is designer?

[kunkumnaveen]

Still ,i couldn't find any solution for the above requirement . Please share your toughs  on the requirement ..

[sunny_talwar]

Try this

If(GetSelectedCount(Category) = 0 or Only({1} Category) = 'prod',

Sum({<Month,Year,Date={">=$(=Date(MonthStart(Max(Date), -5), 'DD-MM-YYYY'))<=$(=Date(Max(Date), 'DD-MM-YYYY'))"}>} p_input)

)

[kunkumnaveen]

Hi sunny ,

Thanks for the reply ....i have written expressions as below 

1)Expression : prod   

If(GetSelectedCount(Category) = 0 or Only({1} Category) = 'prod',

Sum({<Month,Year,Date={">=$(=Date(MonthStart(Max(Date), -5), 'DD-MM-YYYY'))<=$(=Date(Max(Date), 'DD-MM-YYYY'))"}>} p_input)

)

2)Expression : sale

If(GetSelectedCount(Category) = 0 or Only({1} Category) = 'sale',

Sum({<Month,Year,Date={">=$(=date(monthstart(addmonths(max(Date),-5)),'DD-MM-YYYY'))<=$(=date(((max(Date))),'DD-MM-YYYY'))"}>}p_d_OP)
)

Before selecting any value from category :

After selecting  prod from category :

I am getting select either prod or sale or both.......