topic Re: Variables/if statement - summary view in QlikView https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999686#M953414 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>May be like this?</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/107487_Capture.JPG" style="height: auto;" /></P><P>Edit:</P><P></P><P>Chart Inserted. You can move the expression to Variable.</P></BODY></HTML> Fri, 27 Nov 2015 15:16:06 GMT settu_periasamy 2015-11-27T15:16:06Z Variables/if statement - summary view https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999685#M953413 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am brand new to Qlikview this week and have been working my way through tutorials/community threads for help. Unfortunately I cant find the answer to my current problem.</P><P></P><P>I have some underlying data like so:</P><P></P><P>Project number&nbsp;&nbsp;&nbsp;&nbsp; Impacted business dept&nbsp;&nbsp;&nbsp;&nbsp; Time Period&nbsp;&nbsp;&nbsp;&nbsp; Task Frequency&nbsp;&nbsp;&nbsp;&nbsp; Current task duration (mins)</P><P>PRJ0001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RATES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Weekly&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40&nbsp;&nbsp;&nbsp; </P><P>PRJ0002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RATES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Weekly&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20 </P><P>PRJ0003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CREDIT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Weekly&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>PRJ0004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CREDIT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Monthly&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120</P><P>PRJ0005&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CREDIT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Annually&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P></P><P></P><P>In a straight chart I am able to add in a further column 'Yearly Hours', which has "$<SPAN style="font-size: 13.3333px;">(YearlyHoursVar)" - which is a </SPAN>variable like so (which I defined through document properties)</P><P></P><P>Num(if([Time Period] = 'Daily',sum([Current task duration (mins)]*[Task Frequency]*5*52/60),</P><P>if([Time Period] = 'Hourly',sum([Current task duration (mins)]*[Task Frequency]*12*5*52/60),</P><P>if([Time Period] = 'Monthly',sum([Current task duration (mins)]*[Task Frequency]*12/60),</P><P>if([Time Period] = 'Annually',sum([Current task duration (mins)]*[Task Frequency]/60),</P><P>if([Time Period] = 'Weekly',sum([Current task duration (mins)]*[Task Frequency]*52/60))<SPAN style="font-size: 10pt; line-height: 1.5em;">)</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">)</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">)</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">)</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">,'##.')</SPAN></P><P></P><P></P><P style="font-size: 13.3333px;">Project number&nbsp;&nbsp;&nbsp;&nbsp; Impacted business dept&nbsp;&nbsp;&nbsp;&nbsp; Time Period&nbsp;&nbsp;&nbsp;&nbsp; Task Frequency&nbsp;&nbsp;&nbsp;&nbsp; Current task duration (mins)&nbsp;&nbsp; Yearly Hours</P><P style="font-size: 13.3333px;">PRJ0001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RATES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Weekly&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 35</P><P style="font-size: 13.3333px;">PRJ0002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RATES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Weekly&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 35 </P><P style="font-size: 13.3333px;">PRJ0003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CREDIT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Weekly&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</P><P style="font-size: 13.3333px;">PRJ0004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CREDIT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Monthly&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 360</P><P style="font-size: 13.3333px;">PRJ0005&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CREDIT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Annually&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Now this is perfect, just what a want.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">But I also want to build a view of summary by impacted business department.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Expected result:</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">impacted bus. dept&nbsp;&nbsp;&nbsp;&nbsp; Yearly Hours</P><P style="font-size: 13.3333px;">RATES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 70</P><P style="font-size: 13.3333px;">CREDIT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 376 </P><P></P><P>However, I build a straight table with Impacted business department as a dimension and and '$(YearlyHoursVar)' as the expression and it doesn't work. I know the reason why, I just cant figure out how to get round it.</P><P></P><P>The output would be:</P><P></P><P>RATES&nbsp;&nbsp;&nbsp;&nbsp; 70</P><P>CREDIT&nbsp;&nbsp;&nbsp;&nbsp; -</P><P></P><P>This is because rates just has 'weekly' time period, so i guess gets to 'weekly' in the if statement and then ends, whilst credit has 3 options to scroll through but exits the IF after the 'weekly' option so doesn't calculate the other two. </P><P></P><P>I need to iterate through all underlying project records and then add the the total.</P><P></P><P>Can someone please suggest a solution or equally let me know if I have gone the around this the wrong way?</P><P></P><P>Thanks,</P><P></P><P>Lizi</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999685#M953413 2020-11-20T18:02:30Z Re: Variables/if statement - summary view https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999686#M953414 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>May be like this?</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/107487_Capture.JPG" style="height: auto;" /></P><P>Edit:</P><P></P><P>Chart Inserted. You can move the expression to Variable.</P></BODY></HTML> Fri, 27 Nov 2015 15:16:06 GMT https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999686#M953414 settu_periasamy 2015-11-27T15:16:06Z Re: Variables/if statement - summary view https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999687#M953415 <HTML><HEAD></HEAD><BODY><P>Hi Settu,</P><P></P><P>When I try and open your file I get a message saying:</P><P></P><P><IMG alt="QVmsg.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/107486_QVmsg.PNG" style="height: auto;" /></P><P></P><P>I don't really want to do this since I want to be able to open the files created with my current user key!!! Any way around this? or could you give me an overview of your solution? </P></BODY></HTML> Fri, 27 Nov 2015 15:20:31 GMT https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999687#M953415 2015-11-27T15:20:31Z Re: Variables/if statement - summary view https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999688#M953416 <HTML><HEAD></HEAD><BODY><P>oh and also - this needs to be in a chart (Straight table) as there are more than just 'credit' and 'rates' that I need to display! about 50 rows <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Fri, 27 Nov 2015 15:21:18 GMT https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999688#M953416 2015-11-27T15:21:18Z Re: Variables/if statement - summary view https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999689#M953417 <HTML><HEAD></HEAD><BODY><P>I'd calculate a multiplier in the script. And if possible also the Yearly hours. See attached example.</P></BODY></HTML> Fri, 27 Nov 2015 15:22:21 GMT https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999689#M953417 Gysbert_Wassenaar 2015-11-27T15:22:21Z Re: Variables/if statement - summary view https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999690#M953418 <HTML><HEAD></HEAD><BODY><P>please ignore - i asked my org for the license and am now able to open your doc - checking it out! </P></BODY></HTML> Fri, 27 Nov 2015 15:30:53 GMT https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999690#M953418 2015-11-27T15:30:53Z Re: Variables/if statement - summary view https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999691#M953420 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Bit Improved with variable..</P></BODY></HTML> Fri, 27 Nov 2015 16:10:23 GMT https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999691#M953420 settu_periasamy 2015-11-27T16:10:23Z Re: Variables/if statement - summary view https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999692#M953422 <HTML><HEAD></HEAD><BODY><P>Thank you for your help!</P><P></P><P>This worked a charm</P></BODY></HTML> Thu, 03 Dec 2015 16:46:51 GMT https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999692#M953422 2015-12-03T16:46:51Z Re: Variables/if statement - summary view https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999693#M953423 <HTML><HEAD></HEAD><BODY><P>Thank you for your help - I have marked settu's answer as the correct one as it is the solution I went for, but also played around with yours and worked too</P></BODY></HTML> Thu, 03 Dec 2015 16:47:34 GMT https://community.qlik.com/t5/QlikView/Variables-if-statement-summary-view/m-p/999693#M953423 2015-12-03T16:47:34Z