topic Re: Expression conditional in QlikView

Expression conditional

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have the expression sum(sales).

i want to add the following formula if(variable=1,sum(sales)), however with this formula it only applies for the month that variable =1. i would like the expression to calculate the sales for all months if for one month the variable =1.

Thank you

Re: Expression conditional

sunny_talwar — Wed, 07 Dec 2016 10:26:50 GMT

Is variable a field here? or is it truly a variable? How does it get different values for different months if it is truly a variable?

Re: Expression conditional

prat1507 — Wed, 07 Dec 2016 10:34:46 GMT

Hi Pablo

This might work

= if(variable=1,sum({1}sales)),

Regards

Pratyush

Re: Expression conditional

Anonymous — Wed, 07 Dec 2016 10:42:38 GMT

Hello,

@Sunny You are right is a dimension. The dimension gets the valor 1 showing when it started getting sales.

@Pratyush with your expression it gives me the sales when the dimension is one, but no for the following months.

thank you

Re: Expression conditional

sunny_talwar — Wed, 07 Dec 2016 10:45:05 GMT

May be this:

If(Max(TOTAL <Month> variable) = 1, Sum(sales))

or if month is the only dimension you have in the chart, then this:

If(Max(TOTAL variable) = 1, Sum(Sales))

Re: Expression conditional

Anonymous — Wed, 07 Dec 2016 11:41:12 GMT

with both expressions, still the same result i had.

Re: Expression conditional

sunny_talwar — Wed, 07 Dec 2016 12:05:46 GMT

Would you be able to share a sample or show screenshots of what you have?

Re: Expression conditional

Anonymous — Wed, 07 Dec 2016 12:21:00 GMT

Sure, here you have a sample of my data.

Re: Expression conditional

vinieme12 — Wed, 07 Dec 2016 12:23:54 GMT

please post your variable expression

Re: Expression conditional

sunny_talwar — Wed, 07 Dec 2016 12:25:00 GMT

Not 100% sure, but are you looking for something like attached?

Re: Expression conditional

sunny_talwar — Wed, 07 Dec 2016 12:25:37 GMT

vinieme12‌ variable is just a field, it is not a QlikView variable

Re: Expression conditional

Anonymous — Wed, 07 Dec 2016 12:30:10 GMT

what i would like is to have for example a listbox that if for a chosen month, the registraion or drop value = 1 then to show the sum of sales for all months

Re: Expression conditional

sunny_talwar — Wed, 07 Dec 2016 12:33:25 GMT

Check this out:

If(Max(TOTAL Registration) = 1, Sum({<Date>}Sales), Sum(Sales))

Re: Expression conditional

Anonymous — Wed, 07 Dec 2016 12:33:29 GMT

Hi,

Check if this works as per your requirement:-

If(Max(TOTAL <Month> variable) = 1, Sum({<variable=>} Sales))

Re: Expression conditional

Anonymous — Wed, 07 Dec 2016 12:36:35 GMT

what i would like is to have for example a listbox that if for a chosen month, the registraion or drop value = 1 then to show the sum of sales for all months. you have above a sample of my data

Re: Expression conditional

vinieme12 — Wed, 07 Dec 2016 12:57:58 GMT

This

If((sum(TOTAL <Date> Drop)+sum(TOTAL <Date> Registration)) > 0, Sum(Total <Date> Sales) , sum(Sales))

Re: Expression conditional

Anonymous — Wed, 07 Dec 2016 14:24:20 GMT

not really what i was looking

Re: Expression conditional

sunny_talwar — Wed, 07 Dec 2016 14:28:41 GMT

Did you get to check my response above?

Re: Expression conditional

vinieme12 — Wed, 07 Dec 2016 14:31:21 GMT

can you post a table showing expected o/p

Re: Expression conditional

Anonymous — Wed, 07 Dec 2016 15:20:08 GMT

Yes,

I did check it, what i want is for example on january16, there is a registration of a client so i would like to see if a check in january16, to see all the sales of the client that was registered on january 16