topic Misbehaviour in the chart while using user interactive input box in QlikView

Misbehaviour in the chart while using user interactive input box

Thu, 28 Jan 2010 11:46:40 GMT

Hi All,

I have some issues while using the user interactive chart using the input box. In my document there are two images. In first i want to show how many manufacturer have the sale value more than what entered in the input box. And in the second i want to show how many items have the sale value more than what entered in the input box.

When i enter any value in the input box it shows correct value in both the chart. But when there is no value in the input box. It shows the equal numbers in both the chart. As per the data manufacturer data should have been lesser when compared to the itemname. Don't know where i am going wrong. Check the image for better understanding. Hope some one will help me out soon.

Misbehaviour in the chart while using user interactive input box

Thu, 28 Jan 2010 13:25:55 GMT

Hi All,

This is what i have used in the Manufacturer expression

count(if(aggr(sum(SalValue), Year, mfacname)>iDiffValue,1))

and this is what i have used in the Itemname chart expression

count(if(aggr(sum(SalValue), Year, itemname)>iDiffValue,1))

Let me know where i am going wrong.

Misbehaviour in the chart while using user interactive input box

Thu, 04 Feb 2010 14:44:56 GMT

Hi All,

I have attached my document for better understanding of my problem. Hope someone will help me out. It is very urgent pleaseeeeeeeeeee!!!!!!!!

For opening the application use userid:0010012021 and password:c2info99

Regards,

Rikab

Misbehaviour in the chart while using user interactive input box

Wed, 10 Feb 2010 05:24:57 GMT

Hi All,

Still i didn't got any answer for my post. Requesting QlikView team to answer for my post. I need to finish this requirement at the earliest.

Thanks and Regards,

Rikab

Misbehaviour in the chart while using user interactive input box

Tue, 23 Feb 2010 11:55:33 GMT

Hi All,

Why there is no reply till now. Hope some will look into this and help me out.

Thanks and Regards,

Rikab

Misbehaviour in the chart while using user interactive input box

Tue, 23 Feb 2010 13:10:06 GMT

This seems to work in QlikView 9 SR3, released last week.

Tried your qvw, and there was a obvious difference between the charts when I cleared the input field.

Misbehaviour in the chart while using user interactive input box

Thu, 25 Feb 2010 07:22:14 GMT

Hi KJN!

When i click on update i did not find the QlikView 9 SR3. I am able to see only QlikView 9 SR2. By the way i am doing the update for the first time. When i started downloading this seems to be a complete exe. Do i need to install the qlikview once again and i need to enter the license key again?

Thanks and Regards,

Rikab

Misbehaviour in the chart while using user interactive input box

Mon, 08 Mar 2010 12:28:21 GMT

Hi SJN!

I have updated it but still i am not able to over come this problem. Do you or any other facing the same problem.

Thanks and Regards,

Rikab

Misbehaviour in the chart while using user interactive input box

Fri, 19 Mar 2010 05:39:46 GMT

Hi Kjn,

Right now I have updated to QlikView 9 SR3 but still I am facing this problem.

Anyone having solution for this please!

Thanks and Regards,

Rikab

Misbehaviour in the chart while using user interactive input box

Wed, 21 Apr 2010 08:56:24 GMT

Hi All,

I am Rikab writing this post with my own account and previously I was using the my manager's account(Dilip S Jain). Till now i did not get any solution for my problem. Is it is a bug which i am facing here.

It should been answered by qlikview R&D team. Till now I did not get any solution for my problem.

Do you know where I can post this problem? So that QlikView team get noticed.

Thanks and Regards,

Rikab

Misbehaviour in the chart while using user interactive input box

Thu, 22 Apr 2010 11:21:30 GMT

Hi Rikab,

I checked the QVW file you sent. It has again synthetic linking. Please read the manual and understand the implications of such linking. Most probably this is the reason why you are getting wrong results.

Thanks,

Sajeevan

Misbehaviour in the chart while using user interactive input box

Thu, 22 Apr 2010 12:09:01 GMT


Sajeevan wrote:
I checked the QVW file you sent. It has again synthetic linking. Please read the manual and understand the implications of such linking. Most probably this is the reason why you are getting wrong results. <div></div>

Thanks for the quick reply. It is happening in the document even after removing the synthetic key. Give me some time I will remove those synthetic keys from here also and will attach the file. Then it will be easier for you to rectify.

Misbehaviour in the chart while using user interactive input box

michael_anthony — Thu, 22 Apr 2010 12:09:25 GMT

Believe the problem is your expression and what it is comparing against when iDiffValue is blank - or actually is Null. QV doesn't like comparing a Aggr(Sum...) against a Null value so returns true for every record which is why get same value.

Try wrapping iDiffValue in a RangeSum(iDiffValue). this will convert it to 0 if it's Null and your expressions should work as expected.

Misbehaviour in the chart while using user interactive input box

Tue, 27 Apr 2010 07:21:35 GMT

Hi All,

This was the solution given my Mr. Johannes(qlikview) and I suppose it is working.


 Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Hello Rikab,

Your problem here is the null values created for comparison when the variable value is blank, in combination with the data model.
What you can do is add "handling" to the variable so that you check if it's null in the calculation. The following change to the expressions should give the expected results:

count(if(aggr(sum(SalValue), Year, mfacname)>if(len(iDiffValue)=0,-1,iDiffValue),1))
and
count(if(aggr(sum(SalValue), Year, itemname)>if(len(iDiffValue)=0,-1,iDiffValue),1))

There is one problem I am facing in the interactive chart. The problem is that as per the straight table there are only one manufacturer in the year 2006-2007 and it should be only one only. But whereas in the interactive chart it shows "2" manufacturers in the year 2006-2007.

Please check the screen shot and the attached document for you reference.

Hope some one can give me the solution for this problem. Hope it will be Mr. Johannes(qlikview) or Sajeevan agian

userid: 0010012021, password: c2info99

Thanks and Regards,

Rikab

Misbehaviour in the chart while using user interactive input box

Tue, 27 Apr 2010 08:29:44 GMT

Hi Rikab,

I could not open the QV file with the username and password provided in the post.

It is worth checking the exact "mfacname" in your data. If there is an additional space in the name in one of the year (2006 or 2007) may treat it as different manufacturer name while counting the number of manufacturer.

I can check it If you can post the QV file again with right username and password.

Thanks,

Sajeevan

Misbehaviour in the chart while using user interactive input box

Tue, 27 Apr 2010 10:18:50 GMT


Sajeevan wrote:
I could not open the QV file with the username and password provided in the post.
It is worth checking the exact "mfacname" in your data. If there is an additional space in the name in one of the year (2006 or 2007) may treat it as different manufacturer name while counting the number of manufacturer.
I can check it If you can post the QV file again with right username and password. <div></div>

I have the document again and the userid:0010012021 and password:c2info99 is same as before.

I think there is no point in checking whether the mfacname is repeated because if the mfacname name is repeated it should be shown in the straight table also but there it is displaying only once.

So I think there is something else wrong. Let me know if my understanding right or wrong.

Thanks and Regards,

Rikab

Misbehaviour in the chart while using user interactive input box

Tue, 27 Apr 2010 10:51:03 GMT

Hi. You wrote "There is one problem I am facing in the interactive chart. The problem is that as per the straight table there are only one manufacturer in the year 2006-2007 and it should be only one only. But whereas in the interactive chart it shows "2" manufacturers in the year 2006-2007."

If you look at your straigth table it shows 1 for 2006 and 1 for 2007. In your interactive chart these are summed and show 1+1 =2.

Misbehaviour in the chart while using user interactive input box

Tue, 27 Apr 2010 11:18:16 GMT

Hi again. The sinner is your "Year" in your expression

count(if(aggr(sum(SalValue), Year, mfacname)>if(len(iDiffValue)=0,-1,iDiffValue),1))

Remove the Year, and it shows one.

Misbehaviour in the chart while using user interactive input box

Tue, 27 Apr 2010 11:18:18 GMT


DK_ASN wrote:
If you look at your straigth table it shows 1 for 2006 and 1 for 2007. In your interactive chart these are summed and show 1+1 =2. <div></div>

Yes, I agree with your point.But the thing is that I am counting the number of mfacname from April,2006 to March,2007 using this expression

=yearname(Date,0,4)

but it is still showing "2" .

Do you mean to say that if I use the above expression it will sum both the year? Please check and let me know

Do you also mean to say that wherever I am using the expression the values that are calculated or wrong?

Thanks and Regards,

Rikab

Misbehaviour in the chart while using user interactive input box

Tue, 27 Apr 2010 12:53:29 GMT


DK_ASN wrote:
Hi again. The sinner is your "Year" in your expression
count(if(aggr(sum(SalValue), Year, mfacname)>if(len(iDiffValue)=0,-1,iDiffValue),1))
Remove the Year, and it shows one. <div></div>

After removing the year it shows that "No data to display" Please check whether i have done the right change as said by you

Modified Expression:


count(if(aggr(sum(SalValue), mfacname)>if(len(iDiffValue)=0,-1,iDiffValue),1))
count(if(aggr(sum(SalValue), itemname)>if(len(iDiffValue)=0,-1,iDiffValue),1))