topic How to get the Set the Values Default in Line Chart with Original data Point? in QlikView

How to get the Set the Values Default in Line Chart with Original data Point?

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a Chart like below.

From the Above Chart, i need to Bring the value which is more than 2 to 2. But the actual value should be shown as a data point.Like below Screen Shot

I got the above chart But when I try to convert this to Percentage(%). I am getting the data point as 200 % default. It is not showing the actual value

I Need to bring the Value Which is greater than 200% to 200%. by Showing its original value as a data Point

Please find the below attached qvw and Excel data for your reference

I need it in Expression, not in Script and also i need the out in % like above Screen Shot with Original data Points

Kindly Help me Out of this

Thanks,

Muthu

Re: How to get the Set the Values Default in Line Chart with Original data Point?

sunny_talwar — Wed, 07 Jun 2017 17:31:13 GMT

I am not sure what you are looking to get, would you try to re-explain?

Re: How to get the Set the Values Default in Line Chart with Original data Point?

sunny_talwar — Wed, 07 Jun 2017 17:33:35 GMT

Is this what you want?

Change the Number Format on the Number's tab to Expression Default

Re: How to get the Set the Values Default in Line Chart with Original data Point?

Anonymous — Wed, 07 Jun 2017 17:37:47 GMT

A little confused too. But is this what you're trying to get to?

Re: How to get the Set the Values Default in Line Chart with Original data Point?

Wed, 07 Jun 2017 17:52:58 GMT

No . I already got it. the thing is I need it in Percentage. with actual data as a data point.

when I Try to convert it into % I am getting Default as 200% for the values which i restrict to 200%

For Example:

For 3rd data Point, I need to get 1500 % but it is Showing as 200%.

For 5th data point,I need to get 250 % but it is Showing as 200%

Let Me know in case of any Doubts,

Please help me out of this.

Thanks,

Muthu

Re: How to get the Set the Values Default in Line Chart with Original data Point?

sunny_talwar — Wed, 07 Jun 2017 17:56:07 GMT

Use Num() function in your expression

=Dual(Num(Sum(Department), '#,##0%'),if(sum(Department)>'200%','200%',sum(Department)))

Re: How to get the Set the Values Default in Line Chart with Original data Point?

Wed, 07 Jun 2017 18:01:31 GMT

Yeah, this line chart values is what i want.

But Axis is Showing in Numbers I need Axis also to be Shown in %

like 0, 50%,100%,150%,200%

Re: How to get the Set the Values Default in Line Chart with Original data Point?

sunny_talwar — Wed, 07 Jun 2017 18:05:49 GMT

Check it out now

Re: How to get the Set the Values Default in Line Chart with Original data Point?

Wed, 07 Jun 2017 18:06:20 GMT

No, i want the Axis as well as values in %

Re: How to get the Set the Values Default in Line Chart with Original data Point?

Wed, 07 Jun 2017 20:08:37 GMT

Thank you so much sunny .This is what i except.

the above attached data is sample Data for POC .in this i can able to get the out put

but i cant able to match it with my Business that is original Data

In the Place of Num(Sum(Department), '#,##0%') i have used below Expression

=Num((Sum([TGB COUNTS])/Above(TOTAL Sum({<[File Date]>}[TGB COUNTS])) - 1)* Avg(1), '#,##0%') in

So Please Provide me a Solution for my Business(Original data)

Kindly help me

Thanks,

Muthu

Re: How to get the Set the Values Default in Line Chart with Original data Point?

sunny_talwar — Wed, 07 Jun 2017 20:13:37 GMT

What is the expected output here? What is wrong?

Re: How to get the Set the Values Default in Line Chart with Original data Point?

Wed, 07 Jun 2017 20:29:43 GMT

Please find the below Attachment and kindly Look in to Third Sheet

Thanks,

Muthu

Re: How to get the Set the Values Default in Line Chart with Original data Point?

sunny_talwar — Fri, 09 Jun 2017 10:07:01 GMT

I am unable to find a way to make this work.... may be you need to use overlapping charts? Not sure...