topic Re: Line Chart Limitations Not Working in App Development

Line Chart Limitations Not Working

asmithids — Tue, 01 Mar 2016 14:45:36 GMT

Hello,

I have a line chart and a straight table with the same dimensions and measure as follows.

Dimensions:

Effective From Date (Primary Sort)
Currency Code

Measure

(Sum(bidRate) - Above(Total Sum(bidRate))) / Above(Total Sum(bidRate)) (Number format is %)

The issue is that the measure percentage calculates correctly in the straight table, but when I drill down to a specific Currency Code in the line chart, the value is completely wrong even though I am using the exact same measure expression as used in the straight table. Please see attached screen shots.

I am using Qlik Sense 2.2.

Has anyone experienced this issue?

Thank you!

Re: Line Chart Limitations Not Working

sunny_talwar — Tue, 01 Mar 2016 14:49:22 GMT

You can get this right using the newly introduced Sorting within Aggr() functionality. The sortable Aggr function is finally here!

Might be able to help better if you can provide a sample

Re: Line Chart Limitations Not Working

asmithids — Tue, 01 Mar 2016 15:25:31 GMT

Hi Sunny,

I attached the qvf. It's a small app.

Thank you!

Re: Line Chart Limitations Not Working

sunny_talwar — Tue, 01 Mar 2016 15:39:03 GMT

What selections have been made? I am unable to locate the incorrect peak

Re: Line Chart Limitations Not Working

asmithids — Tue, 01 Mar 2016 15:50:38 GMT

Stay on the first sheet, filter on effective from date of 1/05/2016. You'll see the first peak in the preview. That will be the 512 Currency Code. Ignore the second sheet.

Thanks,

Re: Line Chart Limitations Not Working

sunny_talwar — Tue, 01 Mar 2016 16:18:11 GMT

With Date Selected the chart is working now. What would you want to see when no selection has been made?

Re: Line Chart Limitations Not Working

asmithids — Tue, 01 Mar 2016 16:57:03 GMT

Thanks Sunny!

When no filters are selected, I need to see the attached. The aggregated fluctuation per day. Then as I select specific days, the line chart should drill down to all of the Currency Codes for that selected day. Then if the day filter is removed, the remaining Currency Code filter should show the fluctuations across all of the days.

Re: Line Chart Limitations Not Working

sunny_talwar — Tue, 01 Mar 2016 18:20:39 GMT

Do you know if Qlik Sense allows for Conditional Hide/show of dimension? Reddys310‌ - Do you know? I have to Hide effectiveFromDate when GetSelectedCount(effectiveFromDate) = 1

Re: Line Chart Limitations Not Working

asmithids — Tue, 01 Mar 2016 21:38:33 GMT

Currently, Qlik Sense does not allow Conditional Hide/Show of dimensions. I used what you sent back and altered the charts. I made a line chart with just the Effective From Date to show the total fluctuation per date and a separate line chart showing each Currency Code's fluctuation for the selected date. Works well.

As always, thanks for the help Sunny!!!

Re: Line Chart Limitations Not Working

sunny_talwar — Tue, 01 Mar 2016 21:40:48 GMT

Awesome

I wish there was a way to do it, but I am glad you were able to find a work around.

Best,

Sunny

Re: Line Chart Limitations Not Working

reddy-s — Wed, 02 Mar 2016 13:17:41 GMT

Hi Sunny,

That's not yet available Sunny, but you can achieve this using extensions for sure.

Thanks,

Sangram.

Re: Line Chart Limitations Not Working

reddy-s — Wed, 02 Mar 2016 13:18:38 GMT

Let me know if you need any help with building an extesnion. Happy to help 🙂

Re: Line Chart Limitations Not Working

sunny_talwar — Wed, 02 Mar 2016 13:20:23 GMT

Can we have private classes where you teach me how to build extensions .

Re: Line Chart Limitations Not Working

reddy-s — Wed, 02 Mar 2016 13:28:10 GMT

Hahaha . Teaching a guru? Can help you to the best of my knowledge always.

Thanks,

Sangram.

Re: Line Chart Limitations Not Working

asmithids — Wed, 02 Mar 2016 13:46:58 GMT

I have to agree. Sunny is a guru! He has been extremely helpful with everyone on the Community.

Thanks Sunny! You're awesome!