Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
R_Mendoza
Contributor III
Contributor III

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
dplr-rn
Partner - Master III
Partner - Master III

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.

R_Mendoza
Contributor III
Contributor III
Author

Hallo @dplr-rn 

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)

dplr-rn
Partner - Master III
Partner - Master III

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

 

Kushal_Chawda

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))