topic Re: Redundant: Dual() function in Qlik Sense? in App Development

Redundant: Dual() function in Qlik Sense?

Mon, 03 Aug 2015 16:38:37 GMT

Why is the Dual() function available in Qlik Sense?

I cannot use it to to show text labels and sum numeric values for the same field as designed (and works in QlikView). Can anyone from Qlik tell me if this be fixed, removed or if I missed a use case that is still available in sense?

Qlik Sense Application attached. I have also built a simple slope graph in Qlikview using pretty much the same data and expression to show a use case, attached.

I know I can represent the data differently. That said I took this example from a Stephen Few article which is my default for best practice in data visualization PerceptualEdge - Data Vis. I Also know there will likely be an extension on the Qlik Branch that will replicate this example.

This isn't the first function I've found that doesn't work and i'm wondering why, If there is already a function available surely it would work or be removed. I feel like I have missed something obvious, can anyone help explain?

Thanks in advance

Philip Hand

@QlikViewer

Re: Redundant: Dual() function in Qlik Sense?

Gysbert_Wassenaar — Mon, 03 Aug 2015 18:08:23 GMT

That has nothing to do with the dual function which works just fine. It's a limitation of the chart. It just renders the numeric value, period. Hopefully future releases of Qlik Sense will give us more options. And if not, such features can be implemented in extensions.

Re: Redundant: Dual() function in Qlik Sense?

Tue, 04 Aug 2015 13:36:22 GMT

Thanks Gysbert,

If the dual function works fine but not in line charts, what visualizations does it work in?

Re: Redundant: Dual() function in Qlik Sense?

Gysbert_Wassenaar — Wed, 05 Aug 2015 04:59:34 GMT

It works fine in charts, but just not in the one particular case where you want control of the labels on data points.

Re: Redundant: Dual() function in Qlik Sense?

Wed, 05 Aug 2015 10:02:39 GMT

Ok i can picture it working in the script for things like sorting data in the front end, i'm struggling to come up with a use in front end expressions anymore though.

It doesn't matter anyway you answered my question perfectly, many thanks Gysbert, the stickers next to your name are well deserved!

Re: Redundant: Dual() function in Qlik Sense?

tobias_klett — Tue, 28 Jan 2020 15:25:17 GMT

Hi Guys,
I just saw this and tried it anyways. It is now available.
1. Create a Master Item Measure using the Dual() Function
2. Add Measure to Chart
3. Choose "Measure expression" as Number formatting