Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator 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')

9 Replies
MayilVahanan

HI

Try like this

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

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
QSense
Creator II
Creator II
Author

It didnt work correctly

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

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

Regards,

Jagan.

QSense
Creator II
Creator II
Author

It didnt also work

jagan
Luminary Alumni
Luminary Alumni

Hi,

Can you attach sample file?

Regards,

Jagan.

QSense
Creator II
Creator II
Author

Hi jagan,

I have attached file

The issue in TURUNCU HAT - İstekler tab

QSense
Creator II
Creator II
Author

You can test in the chart graph

jagan
Luminary Alumni
Luminary Alumni


Hi,

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

Regards,

Jagan.

QSense
Creator II
Creator II
Author

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