topic Re: Convert QLikView pie-chart with two expressions to QLikSense pie chart in App Development

Convert QLikView pie-chart with two expressions to QLikSense pie chart

qlikmark1990 — Mon, 10 Sep 2018 13:00:51 GMT

First I made a pie-chart in QLikView that has two expressions but no dimension. The two expression in the chart are: =SUM(FactNat) and =SUM(FactInt).

I tried to create the same chart in QLikSense but my problem is that QLikSense obliged me to create a dimension that the current pie chart doesn't contain.

My pie-chart in QLikView

When I added the two expressions to the pie-chart, I don't get a visualization. What do I need to put as dimension to the pie-chart?

I tried to add FactInt as dimension that results to:

And FactNat results to:

How do I get the pie-chart shown in QLikView?

Re: Convert QLikView pie-chart with two expressions to QLikSense pie chart

Lisa_P — Tue, 11 Sep 2018 00:43:05 GMT

Try this:

As a calculated dimension:

=ValueList('FactNat','FactInt')

As your measure:

if(ValueList('FactNat','FactInt')='FactNat',sum(FactNat),

if(ValueList('FactNat','FactInt')='FactInt',sum(FactInt)))

You will need to do some conditional colouring and labelling

Re: Convert QLikView pie-chart with two expressions to QLikSense pie chart

qlikmark1990 — Tue, 11 Sep 2018 09:04:43 GMT

This is exactly what I needed, thanks.

Re: Convert QLikView pie-chart with two expressions to QLikSense pie chart

Dan36 — Fri, 05 Aug 2022 00:32:15 GMT

Nice one - exactly what I needed