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.
