Cyclic Group not showing data

Tue, 17 Feb 2015 05:09:35 GMT

Hi,

I am new to QlikView and run into a scenario where I have a combo chart with two dimension

1. Date

2. Customers (Cyclic Group which has values A,B,C,D etc for example)

In the expressions I have AVG of customers sales for example:

=AVG({$<[Date]={">=$(=Date(vstartDate))<=$(=Date(vEndDate))"},Category={"PRM"}>}Sales)

The problem is when the Cyclic Group icon is appearing on the chart it looks like it doesn't have any data for customers but they are appearing on x axis instead.

What is required here is the cyclic group should allow to select any specific customer and then based on expression it should calculate the AVG of Sales for his PRM category products for the specified date range.

A similar solution like this one is working well without any problem.

Couldn't find out what might be going wrong here and need suggestion.

Re: Cyclic Group not showing data

rubenmarin — Tue, 17 Feb 2015 16:03:13 GMT

Hi, maybe "vstartDate" should be "vStartDate"?

Re: Cyclic Group not showing data

Tue, 17 Feb 2015 17:46:45 GMT

Try adding your dates into a variable. Let us know.

Re: Cyclic Group not showing data

Anonymous — Tue, 17 Feb 2015 17:48:28 GMT

if possible send the part of your app where you are trying to achieve this functionality

topic Re: Cyclic Group not showing data in QlikView

Cyclic Group not showing data

Re: Cyclic Group not showing data

Re: Cyclic Group not showing data

Re: Cyclic Group not showing data