Hi, I dont know whethere any direct way to do this. You can create same chart twice. Make them one overlay other and change the transparency of one of the chart. In one chart you can make the axes as left(do this on Axes Tab of chart properties) and for another chart make the axes on the right. You can try. I'm not sure on this.
Hi BI User,
it's a rather basic example, line chart has a second expression based on the highest and lowest dates and same basic expression as the main expression no line just show values on data points!
165150.qvw 150.2 K
I have tried creating two expressions, one is the main expression and the other one is based on the conditional max and min date sales values .I have also checked the property 'values on data points ' for the 2nd expression only but its still displaying data on all the data points than on the first and last point.
I need help on this as I'm unable to understand what I'm missing on this.
I have tried using two expressions exp1:Sum(sales)
exp 2:if((shpDate= date(min(shpDate)) )or( shpDate=date(max(shpDate))),exp1,'---')(checked the property 'values on data points ' and unchecked line for exp2 )
and achieved the below result but I need sales values for only max and min dates of each product
These lines will represent the sales for different products for the particular date. Also Max & min date for each product will vary
I'm new to qlikview so may have missed something...Any Help on this will be appreciable..
Thanks in advance!!