topic Re: Dashboard does not show all data in QlikView

Dashboard does not show all data

Wed, 09 Apr 2014 13:45:29 GMT

See attachment of issue.

My issue is for bPeriod 8 and 12, the information for newGP, newRevenue and newLoads does not show on the DashBoard when anGP, anLoads, and anRevenue are null. Not sure what you need to resolve this issue. If you need more information, please let me know. tks

Re: Dashboard does not show all data

MK_QSL — Wed, 09 Apr 2014 13:49:58 GMT

Can you share the dashboard you are using for these data?

Re: Dashboard does not show all data

antoniotiman — Wed, 09 Apr 2014 13:50:21 GMT

which is your expression ?

Re: Dashboard does not show all data

Wed, 09 Apr 2014 13:54:53 GMT

can you attach you qvw please.

Re: Dashboard does not show all data

Greg_Hood — Wed, 09 Apr 2014 13:55:03 GMT

Essentially it will depend on what your expression is. If you want to show all the fields and the full table, then your expression must have a value on every row. It's not clear exactly what you want to do with the data, but assume you don't want to summarize it, you could try this (expression is the period) if you want to use a straight table, or just put it all in a table box.

Re: Dashboard does not show all data

Wed, 09 Apr 2014 17:33:01 GMT

This is the expression.

=sum({<bPeriod={"<=$(vCurrPeriod)"},bYear={$(vMaxSelectedYear)}

,bMon={$(vSelectedMonth)},bFQtrS={$(vSelectedQtr)},[Parent Alias Name]=>} newLoads)

Re: Re: Dashboard does not show all data

Wed, 09 Apr 2014 18:38:51 GMT

What is happening is newGP, newLoads, and newRevenue are not showing up on the DashBoard for bPeriod 8 and 12.

My expressions for these three columns are:

Re: Dashboard does not show all data

antoniotiman — Thu, 10 Apr 2014 09:46:39 GMT

You try sum({1<..........

1 means all the data, or $ means only selections

Re: Dashboard does not show all data

Thu, 10 Apr 2014 12:49:59 GMT

This works if I want all (example) sales persons. However, if I only want John Doe to appear when he is selected, I still get everyone.

If in Nov. and Mar. he has zero actuals, but he does have a budget for these months, the budget amounts should appear even though

the actuals are zero. (as per my attachment).tks

Re: Dashboard does not show all data

antoniotiman — Thu, 10 Apr 2014 13:54:23 GMT

If John Doe is [Parent Alias Name] try :

....,[Parent Alias Name]=$::[Parent Alias Name]>} ...