topic Re: Set analysis in QlikView

Set analysis

QSense — Mon, 15 Oct 2012 11:23:51 GMT

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))

Re: Set analysis

jonathandienst — Mon, 15 Oct 2012 11:32:21 GMT

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

Re: Set analysis

kaushiknsolanki — Mon, 15 Oct 2012 11:33:49 GMT

Try this,

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

Regards,

Kaushik Solanki

Re: Set analysis

QSense — Mon, 15 Oct 2012 11:40:02 GMT

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

Re: Set analysis

QSense — Mon, 15 Oct 2012 11:41:14 GMT

It didnt work

Re: Set analysis

kaushiknsolanki — Mon, 15 Oct 2012 11:42:05 GMT

HI,

Could you please send us sample file with few records.

Regards,

Kaushik Solanki

Re: Set analysis

jonathandienst — Mon, 15 Oct 2012 11:44:46 GMT

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)

Re: Set analysis

QSense — Mon, 15 Oct 2012 11:56:48 GMT

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

Re: Set analysis

jonathandienst — Mon, 15 Oct 2012 11:59:40 GMT

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

Re: Set analysis

jonathandienst — Mon, 15 Oct 2012 12:02:45 GMT

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

Re: Set analysis

QSense — Mon, 15 Oct 2012 12:12:29 GMT

As you see, One of your expression works ISTEK_DURUM='Açık' 415

Other expression didnt work

Re: Set analysis

jonathandienst — Mon, 15 Oct 2012 12:15:09 GMT

In what way did it not work? That way we dont have to guess the problem.

Re: Set analysis

jonathandienst — Mon, 15 Oct 2012 12:25:11 GMT

I think the date format is the problem, as stated in earlier posts. From your screen shot, looks like the date format of ISTEK_ACISTARIHI2 is a timestamp. You will need to match that in the Date() statement in the set expression - perhaps:

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

Jonathan

Re: Set analysis

QSense — Mon, 15 Oct 2012 12:52:09 GMT

Hi Jonathan,

Your last expression works about older than 30 days.

As you said my date format DD.MM.YYYY hh:mm:ss

but I wanna two condistion must be satisfied. both 'Açık' and older than 30 days

Re: Set analysis

QSense — Mon, 15 Oct 2012 13:03:00 GMT

İf you want to see,

I will attach a simple file

Thanks for replies.

Re: Set analysis

QSense — Mon, 15 Oct 2012 13:07:14 GMT

Without click for Durum='Açık'I want to see result both satisfies DURUM='AÇIK' and older than 30 days

Re: Set analysis

MayilVahanan — Mon, 15 Oct 2012 13:11:48 GMT

Try like this

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

Hope that helps

Re: Set analysis

jonathandienst — Mon, 15 Oct 2012 13:22:05 GMT

Thats what that expression does. you just need to align the data format in the Date() statement with the format of ISTEK_ACISTARIHI2

Re: Set analysis

jonathandienst — Mon, 15 Oct 2012 13:23:50 GMT

I think that is exactly what I posted an hour or two ago.

Re: Set analysis

MayilVahanan — Mon, 15 Oct 2012 13:29:18 GMT

Hi mr.Jonathan Dienst,

Ya just now noticed it, i think mr. qliekview not notified your expression clearly nu..