Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Pie Chart (SLOW)

Hello everyone,

How can I do that the Pie Chart does not load until the filters are completed...?

thanx.

Renzo

4 Replies
Highlighted
Partner
Partner

unfortunatly no easy answer to the question.

By slow. how long does the load take?

What is the expression used in the pie chart?

You may need to check the whole app for performance issues as well. Use Robs document analyzer as well.

Highlighted
Contributor
Contributor

Hallo @dilipranjith 

Dimension:

=If($(vChartselect) = 'Produktlinie', $(vSprachfeld_PlanPL),
If($(vChartselect) = 'Land', $(vSprachfeld_LandKDNR),
If($(vChartselect) = 'HVT', [Hauptvertretername],
If($(vChartselect) = 'Kunde', [Name Hausgruppe 1],
If($(vChartselect) = 'Produktgruppe', $(vSprachfeld_PlanPGR),
If($(vChartselect) = 'ABCAnalyse', [Kz. ABC Kunde],
If($(vChartselect) = 'Retoure', $(vSprachfeld_RETG),
If($(vChartselect) = 'Reklamation', $(vSprachfeld_RKLA)))))))))

Kennzahlen:

=-$(eGSLJ_Euro) (SUM)

Highlighted
Partner
Partner

hard to diagnose as most of it is in variables. But i think you are have your answer right there. 

If clauses are much slower than set analysis. i dont know if your logic can be convereted. but a lot it could be theoritically be done in set analysis . alternatively create flags while loading data and use  that in set analysis too

 

Highlighted
MVP
MVP

try to convert it into pick(match expression

=Pick(match($(vChartselect) , 'Produktlinie','Land','HVT','Kunde','Produktgruppe','ABCAnalyse','Retoure','Reklamation'),
$(vSprachfeld_PlanPL),
$(vSprachfeld_LandKDNR),
[Hauptvertretername],
[Name Hausgruppe 1],
$(vSprachfeld_PlanPGR),
[Kz. ABC Kunde],
$(vSprachfeld_RETG),
$(vSprachfeld_RKLA))