topic Pie chart values does include date range in QlikView

Pie chart values does include date range

Sat, 27 Aug 2011 07:32:37 GMT

Attached my file , i am having tough time in figuring out an expression to match the values in the staright table to the pie chart . When a user clicks on the pie chart part , corresponding data should appear in the staright table below , the data in the staright table is correct , but not sure how to include the business logiclogic in the pie chart , when ever i click the pie chart , the date range selection dissapperas and the numbers are not matched .

I have to compare ok to ship date/time value with release_date value ....if the ok to ship date/time is less than release date then it has to fall in prior to release date catogory , if the ok to ship date/time is equal to release date then within the release date catogory.

Please take a look at my working file

Thanks

Pie chart values does include date range

Jason_Michaelides — Sat, 27 Aug 2011 18:10:18 GMT

I think the conditional dimension in the pie chart is the issue. Move the IF statement to the script (it's slightly wrong by the way)

=if(date(SHIP_REQUEST.CREATED_DATE)<ANSWER.ANSWER_DATE, ' Prior the Release Date ',

IF(dateSHIP_REQUEST.CREATED_DATE) >= ANSWER.ANSWER_DATE, 'Within Release Date'))

should really be

=if(date(SHIP_REQUEST.CREATED_DATE)<ANSWER.ANSWER_DATE, ' Prior the Release Date ', 'Within Release Date') AS OnSchedule (or an appropriate field name)

Then use this field in your pie chart.

Hope this helps,

Jason

Pie chart values does include date range

Jason_Michaelides — Thu, 01 Sep 2011 10:46:39 GMT

Did this solve your problem?

Jason

Pie chart values does include date range

Thu, 01 Sep 2011 16:43:40 GMT

yes ...slight change in the expression solved it ..thank you!!