topic Re: Vizlib sparklines in App Development

Vizlib sparklines

hamza99a — Thu, 02 Aug 2018 17:47:08 GMT

I would like to show the sparklines based on two date fields. I have an open date field and production date field. I also have a field called deposits_balance_amt. Essentially I would like to show a running sum of the data from my min production date to today IF my open date has been within the this year. For some reason when I use set analysis or if statements my sparklines show a 0 value. Any help would be greatly appreciated.

Re: Vizlib sparklines

groveliam — Thu, 02 Aug 2018 18:14:10 GMT

Re: Vizlib sparklines

hamza99a — Thu, 02 Aug 2018 18:16:35 GMT

Re: Vizlib sparklines

BalaBhaskar_Qlik — Fri, 03 Aug 2018 08:51:09 GMT

What are the Expressions you're using?

Post some sample data, to get an idea on issue.

Re: Vizlib sparklines

juraj_misina — Fri, 03 Aug 2018 10:29:57 GMT

First try the expression and dimension you use for sparklines in a standalone table to see if it is working.

Re: Vizlib sparklines

hamza99a — Fri, 03 Aug 2018 13:15:40 GMT

so the expression works and i get sparklines that show the sum for the day. However, I need to see a cumulative summation in the sparklines.

Thanks

Re: Vizlib sparklines

BalaBhaskar_Qlik — Fri, 03 Aug 2018 14:18:06 GMT

May be add Cumulative sum like this:

RangeSum(Above(TOTAL Sum(Amount), 0, ColumnNo(TOTAL)))

Re: Vizlib sparklines

hamza99a — Fri, 03 Aug 2018 14:34:34 GMT

For those that asked this is my set analysis formula for the sparklines:

sum({1<open_dt = {">$(=min([Production Date]))"}>}Deposits_curr_bal_amt)

Re: Vizlib sparklines

groveliam — Fri, 03 Aug 2018 14:36:24 GMT

Excuse me ma'am can you please give more information