topic Re: How to write condition enabling in expression in QlikView

How to write condition enabling in expression

kunkumnaveen — Sat, 16 Nov 2024 00:55:50 GMT

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

Re: How to write condition enabling in expression

Lisa_P — Thu, 02 Apr 2020 03:21:50 GMT

What are you expecting to see?

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

Re: How to write condition enabling in expression

kunkumnaveen — Thu, 02 Apr 2020 03:54:30 GMT

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.

Re: How to write condition enabling in expression

kunkumnaveen — Thu, 02 Apr 2020 09:27:58 GMT

Any suggestion on how to write condition in expression plz

Re: How to write condition enabling in expression

kunkumnaveen — Fri, 03 Apr 2020 09:27:00 GMT

Hello All , Kindly suggest on the above requirement plz

Re: How to write condition enabling in expression

nelsei1n — Fri, 03 Apr 2020 10:24:42 GMT

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

Re: How to write condition enabling in expression

kunkumnaveen — Tue, 07 Apr 2020 10:40:07 GMT

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

Re: How to write condition enabling in expression

kunkumnaveen — Tue, 07 Apr 2020 10:48:28 GMT

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

Re: How to write condition enabling in expression

sunny_talwar — Tue, 07 Apr 2020 10:59:38 GMT

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) )

Re: How to write condition enabling in expression

kunkumnaveen — Tue, 07 Apr 2020 11:11:55 GMT

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.......

Re: How to write condition enabling in expression

kunkumnaveen — Tue, 07 Apr 2020 11:13:45 GMT

I am getting error either i select prod or sale or both from Category

Re: How to write condition enabling in expression

sunny_talwar — Tue, 07 Apr 2020 11:18:40 GMT

Can you try adding TOTAL within the Only() function also

If(GetSelectedCount(Category) = 0 or Only({1} TOTAL Category) = 'prod', Sum({<Month,Year,Date={">=$(=Date(MonthStart(Max(Date), -5), 'DD-MM-YYYY'))<=$(=Date(Max(Date), 'DD-MM-YYYY'))"}>} p_input) )

Re: How to write condition enabling in expression

kunkumnaveen — Tue, 07 Apr 2020 11:19:37 GMT

When i slight change the expression, i am able to see the chart but only for selected Year,Month(2019 ,dec) .

the drawback of this expression is it not ignoring Year,Month

If(GetSelectedCount(Category) = 0 or Category='sale',

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

Re: How to write condition enabling in expression

sunny_talwar — Tue, 07 Apr 2020 11:22:16 GMT

Would you be able to share a qvf sample to show the issue?

Re: How to write condition enabling in expression

kunkumnaveen — Tue, 07 Apr 2020 11:25:54 GMT

HI,

the file is in the server , which i have no access .....what i do is i will create a qvf with some dummy data in my desktop and will share the qvf in 30 min ...

Re: How to write condition enabling in expression

sunny_talwar — Tue, 07 Apr 2020 11:49:43 GMT

Sounds good.

Re: How to write condition enabling in expression

kunkumnaveen — Tue, 07 Apr 2020 12:21:17 GMT

Hello Sunny,

As requested ,please find the attached sample QVF file

Re: How to write condition enabling in expression

sunny_talwar — Tue, 07 Apr 2020 12:55:09 GMT

It was my bad all along... try this

If(GetSelectedCount(Category)=0 or Only({1<Category = p(Category)>} Category) = 'prod', Sum({<Month, Year, Date = {">=$(=Date(MonthStart(Max(Date),-5), 'DD-MM-YYYY'))<=$(=Date(Max(Date), 'DD-MM-YYYY'))"}>} p_input) )

Re: How to write condition enabling in expression

kunkumnaveen — Tue, 07 Apr 2020 13:32:26 GMT

Hello Sunny, thanks for your concern and sorry for annoying you.

I still find two issues in the file you have shared

1) If there is Year and Month selection , the chart is showing only the selected Year,Month bar or Line.In fact it suppose to bypass the Year and Month Selection(It is working if no year and Month is selected)

2)IF i select both prod and sale , the chart is showing error . In real time data i have 5 different values in category so which means there will be five expression.

so user need flexibility to chose either one or two or three or more values from category......

Re: How to write condition enabling in expression

kunkumnaveen — Tue, 07 Apr 2020 13:49:08 GMT

Hello

Screen1(No Year and Month selection only Category='prod')

Screen2( Year and Month selected and Category='prod')

Screen1(Year and Month selection and Category='prod' and Category='sale')