topic Re: Set analysis - compare two value for calculation in QlikView

Set analysis - compare two value for calculation

Wed, 08 May 2013 15:32:40 GMT

Hello,

I'm having this issue and couldn't be able to figure it out. Please help.

I am having two condition on my calculation, below is my expression. I'm using chart pivot table

=count({<columnA={'A'}, column_id_a=column_id_b >} DISTINCT column_ticket

)

Name	#assigned	#closed
agent A	250	150

Thanks,

Trisha

Re: Set analysis - compare two value for calculation

Clever_Anjos — Wed, 08 May 2013 16:21:01 GMT

try

=count({<columnA={'A'}, column_id_a=P(column_id_b) >} DISTINCT column_ticket)

and check if is what you need

Re: Set analysis - compare two value for calculation

Wed, 08 May 2013 16:43:34 GMT

it works perfectly. Thank you so much Clever Anjos. You're the best!!!!

Re: Set analysis - compare two value for calculation

Clever_Anjos — Wed, 08 May 2013 17:07:45 GMT

You´re welcome.

So please mark it as correct answer and let me collect some points

Re: Set analysis - compare two value for calculation

Wed, 08 May 2013 17:22:42 GMT

I thought I did. Please check again and see if i did correctly.

First time to post a request in this forum.

Re: Set analysis - compare two value for calculation

Wed, 08 May 2013 18:53:00 GMT

hi "Clever Anjos", would you please help me one more issue related to it?

here is my syntax but it doesn't work. Since my first two filter work fine, but it gave me too much duplicate record so i have to add one for filter for date.

=count({<columnA={'A'}, column_id_a=P(column_id_b), column_date1=date(column_date2, 'MM/DD/YYYY') >} DISTINCT column_ticket)

note: column_date1 has this format 03/01/2013

column_date2 has this format 03/01/2013 08:15:45

I appreciate your help.

Trisha

Re: Set analysis - compare two value for calculation

Clever_Anjos — Wed, 08 May 2013 20:50:15 GMT

Try this:

=count({<columnA={'A'}, column_id_a=P(column_id_b), column_date1={"$(=date(column_date2, 'MM/DD/YYYY'))"} >} DISTINCT column_ticket)

Re: Set analysis - compare two value for calculation

Wed, 08 May 2013 21:36:11 GMT

Hello,

Thanks for response. I tried it several times even changed the date format but none of it works for me.

This time it show 0.

Re: Set analysis - compare two value for calculation

Clever_Anjos — Wed, 08 May 2013 22:21:54 GMT

Could you post a qvw?

I´ll do it for you.

Re: Set analysis - compare two value for calculation

Thu, 09 May 2013 15:14:30 GMT

i'm having a problem with uploading the qvw file. Still searching how to do it.

Re: Set analysis - compare two value for calculation

Thu, 09 May 2013 15:27:11 GMT

ah, i can upload the file now. 🙂

Re: Set analysis - compare two value for calculation

Clever_Anjos — Thu, 09 May 2013 16:56:05 GMT

It woulb nicer if you have a field with TL_IM_Open_Time formatted

I´ve done with "if" (it´s not the better way, but works)

Download it at : https://docs.google.com/file/d/0B-gcl9bj_QQJVDcyZUpKVmh5WlE/edit?usp=sharing

Re: Set analysis - compare two value for calculation

Thu, 09 May 2013 17:00:00 GMT

Hi,

Yes, i have formatted the _Open_Time field in the original file.

btw, i can't open the link you sent, keep showing "internet explorer can't displayed".

Thanks!

Re: Set analysis - compare two value for calculation

Clever_Anjos — Thu, 09 May 2013 17:47:03 GMT

There´s a link to donwload

Re: Set analysis - compare two value for calculation

Thu, 09 May 2013 19:59:39 GMT

Hi,

There is a blocked on proxy server from work, so i have to send the link to ask someone download it for me. 😞

Thanks for the file. I had it here and tested it. The assigned works fine, but the "touched" didn't work.

It doesn't like "not in --> -= ) syntax so it still returned 0

Thank you so much for helping me out. I'm stuck with this for couple days now.