Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
qlikmark1990
New Contributor III

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

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.

pie chart.png

My pie-chart in QLikView

2018-09-10_1453.png2018-09-10_1454.png

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:

2018-09-10_1458.png

And FactNat results to:

2018-09-10_1458_001.png

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

Tags (1)
1 Solution

Accepted Solutions
Employee
Employee

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

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

View solution in original post

2 Replies
Employee
Employee

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

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

View solution in original post

qlikmark1990
New Contributor III

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

This is exactly what I needed, thanks.