topic Re: Conditional Filter in App Development

Conditional Filter

adminkare — Thu, 07 Feb 2019 12:13:45 GMT

hi,

I created a table. Too many rows of tables. I have reduced the number of lines by giving condition 1 and 0.

Calculation:

if([DOGUM TARIHI]>='25.06.2000' and [DOGUM TARIHI]<='31.03.2001', 1,0)

Im sending screenshot.

I want to that with zero row... go about with 1 and 0 rows...

for exm:

Column1 Column2

a 1

b 0

Column2-> Measures " if([DOGUM TARIHI]>='25.06.2000' and [DOGUM TARIHI]<='31.03.2001', 1,0) "

Column1-> Dimensions

Thx u..

Re: Conditional Filter

pradosh_thakur — Thu, 07 Feb 2019 14:12:39 GMT

May be this

if([DOGUM TARIHI]>=date#('25.06.2000' ,'DD.MM.YYYY') and [DOGUM TARIHI]<=date#('31.03.2001','DD.MM.YYYY') 1,0)

Re: Conditional Filter

adminkare — Thu, 07 Feb 2019 17:23:49 GMT

yes true. This is work... but:

I want to choose to 1 values... I send to screenshot. 5 row this. there is Only one "1 values"...

for examle..

if([DOGUM TARIHI]>=date#('25.06.2000' ,'DD.MM.YYYY') and [DOGUM TARIHI]<=date#('31.03.2001','DD.MM.YYYY') 1,0)

after this work, will be result:

column1 column2

a 1

b 1

c 1

d 1

"if" condition, get "0 values" rows too.

i dont want to "0 values" rows.. because "0 values" have 1 million row...

thank you

Re: Conditional Filter

pradosh_thakur — Thu, 07 Feb 2019 17:27:59 GMT

put a where condition like in script

where [DOGUM TARIHI]>=date#('25.06.2000' ,'DD.MM.YYYY') and [DOGUM TARIHI]<=date#('31.03.2001','DD.MM.YYYY') )

don't hard the value is my advice

Re: Conditional Filter

pradosh_thakur — Thu, 07 Feb 2019 17:29:45 GMT

Else create a field in sxcript

if([DOGUM TARIHI]>=date#('25.06.2000' ,'DD.MM.YYYY') and [DOGUM TARIHI]<=date#('31.03.2001','DD.MM.YYYY') 1,0) as flag

then in chart

sum({<flag={1}>}measure)

Re: Conditional Filter

adminkare — Fri, 08 Feb 2019 17:43:07 GMT

Tanks sir..

Its Be 🙂

Re: Conditional Filter

pradosh_thakur — Fri, 08 Feb 2019 17:54:55 GMT

Please close the thread if your query is answered, else let me know.

Re: Conditional Filter

adminkare — Fri, 08 Feb 2019 18:22:06 GMT

yes sir.

it was your solution.

thank you.