topic Re: Getting the following errors after developing dashboard in QlikView

Getting the following errors after developing dashboard

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

1. Getting the following Sales Report error.

a. The relevant Totals and Subtotal are not Correct(i am using pivot table and using show partial sums)

b. I want the Default dates from 1 Jan of each year

c. The Growth and Variance figures are mathematically correct(current year)-(previous year)/(previous year)

2. On Default dates, is it possible to make the dates starting beginning of the month, instead of beginning for the year. So for Apr, the default ‘from’ date could be Apr 1 (not Jan 1 ).

Re: Getting the following errors after developing dashboard

YoussefBelloum — Mon, 23 Apr 2018 12:02:57 GMT

Hi,

1).a) you should maybe aggregate your expressions on the dimensions used on your pivot table

1.b) you should be able to do this using set analysis

1.c) already ok

2) you should be able to do this using set analysis

you can add more details here ? like sample data ? sample app ?

Re: Getting the following errors after developing dashboard

Anonymous — Mon, 23 Apr 2018 12:11:46 GMT

1. i am using following expression

=num(count({ stateA<Sold_Date = {">=$(vstart)<=$(vend)"} >}DISTINCT SAPCode),'#,##0.0')

now what changes should i do in the expression ?

2 How to implement same using triggers?

On Default dates, is it possible to make the dates starting beginning of the month, instead of beginning for the year. So for Apr, the default ‘from’ date could be Apr 1 (not Jan 1)

.So, I want

Before previous Year- 1st april 2016 -one day before current date

vstart variable used for calender and vend date for calender 2016) StateA

simillarly for 1st april 2017 till one day before current date (vStartDate - Vend Date for calender 2017)StateB

and same for current Year, Please tell how to handle the following above points ?

Re: Getting the following errors after developing dashboard

YoussefBelloum — Mon, 23 Apr 2018 12:21:33 GMT

if you only have DistChannel as a dimension on your pivot table, you can try this:

=num(sum({ stateA<Sold_Date = {">=$(vstart)<=$(vend)"} >} aggr(count({ stateA<Sold_Date = {">=$(vstart)<=$(vend)"} >}DISTINCT SAPCode),[DistChannel])),'#,##0.0')

PS: verify the DistChannel field name before writing it on the expression

Re: Getting the following errors after developing dashboard

Anonymous — Mon, 23 Apr 2018 12:37:56 GMT

this expression is for total no of bills

=num(count({stateA < Sold_Date = {">=$(vstart)<=$(vend)"} >} DISTINCT [inv no]))

Re: Getting the following errors after developing dashboard

Anonymous — Mon, 23 Apr 2018 12:41:14 GMT

This expression is for calculating discount %

=((sum({stateA < Sold_Date = {">=$(vstart)<=$(vend)"} >} quantity_sold * MRP_INR)

- sum({stateA < Sold_Date = {">=$(vstart)<=$(vend)"} >}quantity_returns * MRP_INR))

( sum({stateA < Sold_Date = {">=$(vstart)<=$(vend)"} >} [inv value])))

(sum({stateA < Sold_Date = {">=$(vstart)<=$(vend)"} >}quantity_sold * MRP_INR)

- sum({stateA < Sold_Date = {">=$(vstart)<=$(vend)"} >} quantity_returns * MRP_INR))

Re: Getting the following errors after developing dashboard

naveenkumarchin — Mon, 23 Apr 2018 13:42:14 GMT

if you are looking for a function to start the dates from beginning of month, you can use Monthstart() function in qlikview.

Re: Getting the following errors after developing dashboard

Anonymous — Tue, 24 Apr 2018 03:31:54 GMT

i want when I open the application the dashboard should display by default starting calendar date as start of current month and end calendar date as todays date-1 so how to implement using triggers?