Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

QSense
Contributor II

Set analysis

Hello,

I have a condition that get data older than 30 days and data's ISTEK_DURUM='Açık'

When ı enter below expression I can not take result

How can ı do this with set analysis

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

Tags (1)
1 Solution

Accepted Solutions

Re: Set analysis

HI

Try like this

=Count({<ISTEK_ACISTARIHI2 = {"<=$(=Timestamp(Today() - 30, 'DD.MM.YYYY hh:mm:ss'))"},ISTEK_DURUM={'Açik'}>} ISTEK_ACISTARIHI2)

Hope that helps

21 Replies
MVP
MVP

Re: Set analysis

Hi

I am afraid your query does not appear to make sense to me, but assuming I understand what you need correctly, try this

=Count({<ISTEK_ACISTARIHI2 = {"<=$(=Date(Today() - 30))"}>} ISTEK_ACISTARIHI2)

+Count({<ISTEK_DURUM={'Açik'}>} ISTEK_DURUM)

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Re: Set analysis

Try this,

Count({<ISTEK_ACISTARIHI2 = {">=Addmonths(ISTEK_ACISTARIHI2,-1)"},ISTEK_DURUM = {"Açık"}>}ISTEK_DURUM)

Regards,

Kaushik Solanki

QSense
Contributor II

Re: Set analysis

It didnt work

your query get same result with the Count({<ISTEK_DURUM={'Açik'}>} ISTEK_DURUM) query

I want to show both data's status 'Açık' and data's created date older than 30 days

in my example data with ISTEK_DURUM='Açık' =450 and

data created date older than 30 days (Count(if(today()-30 >=ISTEK_ACISTARIHI2,ISTEK_ACISTARIHI2))  =  264

QSense
Contributor II

Re: Set analysis

It didnt work

Re: Set analysis

HI,

Could you please send us sample file with few records.

Regards,

Kaushik Solanki

MVP
MVP

Re: Set analysis

Hi

The expression assumes that ISTEK_ACISTARIHI2 is in the default date format for your system (for example YYYY/MM/DD or MM/DD/YYYY). If it is in a different format, then change the expression to explicitly format the date to match the format of ISTEK_ACISTARIHI2:

=Count({<ISTEK_ACISTARIHI2 = {"<=$(=Date(Today() - 30, 'DD/MM/YYYY'))"}>} ISTEK_ACISTARIHI2)

+Count({<ISTEK_DURUM={'Açik'}>} ISTEK_DURUM)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
QSense
Contributor II

Re: Set analysis

biray.png

Hi,

What I mean is that there are two columns above pointed with red 'Açılış_tarihi' and 'Durum'

Açılış_tarihi = ISTEK_ACISTARIHI2 and Durum=ISTEK_DURUM

I wanna to see both Açılış_tarihi  older than 30 days and durum='Açık'

İn the picture ,in below part there are two numbers 415 equals ISTEK_DURUM='Açık'

ISTEK_ACISTARIHI2 older than 30 days and Istek_durum='Açık' equals 264

MVP
MVP

Re: Set analysis

So you want two expressions, like this?

=Count({<ISTEK_ACISTARIHI2 = {"<=$(=Date(Today() - 30, 'DD/MM/YYYY'))"}>} ISTEK_ACISTARIHI2)

=Count({<ISTEK_DURUM={'Açik'}>} ISTEK_DURUM)

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP
MVP

Re: Set analysis

Correction - like this:

=Count({<ISTEK_ACISTARIHI2 = {"<=$(=Date(Today() - 30, 'DD/MM/YYYY'))"}, ISTEK_DURUM={'Açik'}>} ISTEK_ACISTARIHI2)

=Count({<ISTEK_DURUM={'Açik'}>} ISTEK_DURUM)

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser