Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

QSense
Contributor II

expression satisfy multiple condition

Hi,

My expression does not work correctly, when I select Statu as 'Açık'  and date older than 30 days from ISTEK_ACISTARIHI2

One of them is not affected

=Count(if(ISTEK_ACISTARIHI2>=30 ,ISTEK_ACISTARIHI2) and ISTEK_DURUM='Açık')

Tags (1)
9 Replies

Re: expression satisfy multiple condition

HI

Try like this

=Count(if(ISTEK_ACISTARIHI2>=30 and ISTEK_DURUM='Açık' ,ISTEK_ACISTARIHI2))

Hope it helps

QSense
Contributor II

Re: expression satisfy multiple condition

It didnt work correctly

MVP
MVP

Re: expression satisfy multiple condition

Hi,

Try like this

Count({<ISTEK_ACISTARIHI2={'>=30'}, ISTEK_DURUM={'Açık'}>} ISTEK_ACISTARIHI2)

Regards,

Jagan.

QSense
Contributor II

Re: expression satisfy multiple condition

It didnt also work

MVP
MVP

Re: expression satisfy multiple condition

Hi,

Can you attach sample file?

Regards,

Jagan.

QSense
Contributor II

Re: expression satisfy multiple condition

Hi jagan,

I have attached file

The issue in TURUNCU HAT - İstekler tab

QSense
Contributor II

Re: expression satisfy multiple condition

You can test in the chart graph

MVP
MVP

Re: expression satisfy multiple condition


Hi,

Can you explain clearly what you want to do in this chart?

Regards,

Jagan.

QSense
Contributor II

Re: expression satisfy multiple condition

Hi,

=date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')ISTEK_DURUM
19.11.2012AçıkDimension=date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')
12.11.2012Açık
05.11.2012Kapalı
29.10.2012Açık
22.10.2012Kapalı
15.10.2012Açık
08.10.2012Açık
01.10.2012Açık

I can explain in sample.

In list above I want to display in chart and my dimension as you see.

but my need is that When I looked in 05.11.2012 date I want to display 30 days and older before 05.11.2012  date and ISTEK_DURUM="Açık"

For each date I would like to see this information

For instance from the wiew of 19.11.2012 how many request satisfy my need

these three rows satsify my need

15.10.2012Açık
08.10.2012Açık
01.10.2012Açık

How can I write an expression to satisfy my need from the each date view?

As you see above, Count(if(ISTEK_ACISTARIHI2 >=30,ISTEK_ACISTARIHI2, ISTEK_DURUM='Açık')) wtih this expression , ıt brings total amount 8 but ıt should bring zero since ISTEK_ACISTARIHI2 is not older than 30 days

if ISTEK_ACISTARIHI2 older than 30 days and ISTEK_DURUM ='Açık' , ıt must count total rows both satisfies two conditions

Community Browser