Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
The offsetting check box in QlikView doesn't exist in Qlik Sense. Anyone out there who knows how to create a Waterfall chart in Qlik Sense?
Regards,
Pedro
Qlik Sense extensions open up for customized chart objects or presentation. Qlik Branch is a forum where developers can share open projects. This might be a good place to look for available extensions and ongoing developments.
I think you need to build extension
Can you use transparent bars and stacking those with the bars you want to show? That way you should also be able to simulate a waterfall.
Qlik Sense extensions open up for customized chart objects or presentation. Qlik Branch is a forum where developers can share open projects. This might be a good place to look for available extensions and ongoing developments.
Offsets in charts are necessary to produce waterfall charts and Gantt style chart. Hope to see this feature in a future release.
Hi check this
Hi, Rangaraju R
I am using the model you showed (Dynamic Waterfall) but I only can filter one field.
How can I adjust the script to be able to apply unlimited filters (I have sales group, area, month/year, for example)?
Thanks a lot!!
Hi Douglas,
This worked for me:
Using Rangaraju R's example the updated script for Step_1 and Step_2 for two filters - Year and Quarter - would be:
Step_1:
Load
"YEAR",
"Quarter",
SUM(REV_A) as Rev_A,
SUM(REV_B) as Rev_B,
SUM(REV_C) as Rev_C,
SUM(COGS) as COGS,
SUM(EXPENSES) as Expenses,
SUM(LOSS) as Loss,
SUM("NET INCOME") as [Net Income]
Resident Dynamic_Data Group By "YEAR", "Quarter";
Drop Table Dynamic_Data;
Step_2:
Crosstable(Stage,Amount,2)
Load * Resident Step_1;
Drop Table Step_1;
Thank you, very very much, Peter!
It works fine for me!