topic Re: Bar chart Problem in QlikView

Bar chart Problem

krishna20 — Thu, 08 Jan 2015 07:09:38 GMT

Hi friends,

In my bar chart i need to show bottom 20 customers.In this i have both positive and Negative values.My chart is showing only negative values but not positive values.I set Static Max also.But no luck.Please find the attachment.

Any help will be appreciated .

Thanks in Advance.

Regards

Krishna

Re: Bar chart Problem

Thu, 08 Jan 2015 07:12:36 GMT

pls share some sample data

Re: Bar chart Problem

Thu, 08 Jan 2015 07:23:59 GMT

Hello Manoj,

Please check once the Y axis (Expression values) If there is huge data difference in -ve & +ve valuse it will not display.

Re: Bar chart Problem

NareshGuntur — Thu, 08 Jan 2015 07:45:49 GMT

Hi Krishna,

I suggest you to change that to a straight table and see if the data is coming as expected. Then you can corner bar chart for the correct result.

Cheers,

Naresh

Re: Bar chart Problem

krishna20 — Thu, 08 Jan 2015 07:48:46 GMT

Hi Naresh,

Please find the attachment , in that i'm showing both straight table and bar chart result as well as properties snapshot.

Regards

Krishna

Re: Bar chart Problem

kiranmanoharrode — Thu, 08 Jan 2015 08:00:15 GMT

Hi Krishna,

As per my understanding of this issue, you want to show only bottom 20 customers in bar chart. If we consider +ve and -ve Values, the customers with most -ve value will be the bottom customer. heance if you sort a bar chart with expression Descending order the largest negative value customer will be displayed 1st.

For Generating required output.

Go to Dimension Limits in chart properties -> select Customer Dimension -> check the Option of Restrict which values are displayed using the first expression -> check radio box SHOW ONLY -> select drop down option of Smallest -> Mention 20 in Text box( for showing bottom 20 customers).

I think above procedure may solve the required issue.

Regards,

Kiran

8976977897

Re: Bar chart Problem

NareshGuntur — Thu, 08 Jan 2015 08:01:09 GMT

Ok fine. Hope you have checked if Dimension Limits is enabled. I don't see any other issue apart from this.

Cheers,

Naresh

Re: Bar chart Problem

krishna20 — Thu, 08 Jan 2015 08:07:45 GMT

Hi Naresh,

Pls find the Dimension Limits screen shot which i used .Is there any wrong in this and guide further.

Regards

Krishna

Re: Bar chart Problem

kiranmanoharrode — Thu, 08 Jan 2015 08:17:03 GMT

Uncheck the option of Show others

Re: Bar chart Problem

NareshGuntur — Thu, 08 Jan 2015 08:18:07 GMT

Thanks Krishna.

Please try using Largest and check if you are able to see the positive values.

I doubt as there are zeros in your data, the negative and 0 values are counting up to 20 (which you have given in the dimension limits) and so no positive values are coming up.

Or you can change that to some 40 in Dimension Limits and check.

I am unable to see the full image of your bar chart as there is a scroll bar. Show Others check box should be showing you the sum of all positive values.

Cheers,

Naresh

Re: Bar chart Problem

krishna20 — Thu, 08 Jan 2015 08:24:52 GMT

Hi Naresh,

I checked all the possibilities which we can do Prospectively .But No luck. Then only i approached our friends, not able to find where is the minute mistake or we need to apply any settings.

Regards

Krishna

Re: Bar chart Problem

krishna20 — Thu, 08 Jan 2015 08:27:59 GMT

Hi all ,

Sorry I forgot to say one thing here.I took dimension as drill down which is combo of company and policy No.

.Its working in straight table not in Bar chart.

Regards

Krishna

Re: Bar chart Problem

NareshGuntur — Thu, 08 Jan 2015 08:28:34 GMT

This is interesting.

Can you share your qvw with all the other tables dropped, script removed and the charts deleted except the straight table and the bar chart.

Cheers,

Naresh

Re: Bar chart Problem

krishna20 — Thu, 08 Jan 2015 08:30:47 GMT

Hi Kiran,

Thank you for the response,

I have applied the above procedure only.Please find the second screen shot and kindly let me know if anything is missing from your steps.

Regards

Krishna

Re: Bar chart Problem

kiranmanoharrode — Thu, 08 Jan 2015 08:34:39 GMT

Hi Krishna,

You are using Drill-down dimension as Company -> Policy No. or Company&'-'&Policy No.

In 1st Scenarion, if you are at Company level then it may be working.

but in 2nd scnearion, you need to bypass policy No using set analysis in expression

Regards,

Kiran

Re: Bar chart Problem

qlikpahadi07 — Thu, 08 Jan 2015 08:35:57 GMT

Hi Krishna,

I have not seen any sample attachment, request you to please share and if possible the output which will make more clear to understand the issue.

Re: Bar chart Problem

krishna20 — Thu, 08 Jan 2015 09:58:56 GMT

Hi All,

I'm attaching sample file here, Please watch it and suggest me .It's an important one for me.

Regards

Krishna

Re: Bar chart Problem

krishna20 — Thu, 08 Jan 2015 10:48:21 GMT

Hi All,

Is there any chance to solve it?

Regards

Krishna

Re: Bar chart Problem

NareshGuntur — Thu, 08 Jan 2015 10:59:00 GMT

Hi Krishna,

The answer is there in one my previous replies above

"I doubt as there are zeros in your data, the negative and 0 values are counting up to 20 (which you have given in the dimension limits) and so no positive values are coming up."

Just go to Presentation and Uncheck "Suppress Zero-Values" and check Zero on Bars. You'll be able to see all the 20 values and most of them are zeros and that is the reason the bar chart is not showing anything till now.

Cheers,

Naresh

Re: Bar chart Problem

rubenmarin — Thu, 08 Jan 2015 11:02:27 GMT

Hi Krishna, in the graph you have "Supress Zero Values" checked. Dimension Limit, Rank and RowNo() will count all this "0" values even if they aren´t show in the chart, so te remaining policies not showing are those which have a sum()=0.

If you want to remove the policies with value 0 you can change the fields in the group to a calculated dimension:

Policy No: =Aggr(Only({<TP_POLICY_NO={"=sum({<TP_TXN_TYPE={POL}>}TP_GrossPremium_LC_1)<>0"}>} TP_POLICY_NO), TP_POLICY_NO)

Company: =Aggr(Only({<COMP_NAME={"=sum({<TP_TXN_TYPE={POL}>}TP_GrossPremium_LC_1)<>0"}>} COMP_NAME), COMP_NAME)

This way dimension limit will filter the values previously filtered by the calculated dimension.