cross table reflecting charts

[kunkumnaveen]

Hi All ,

i got this problem after using this CROSS TABLE function, before using that function my chart displayed data but after using this function there are showing no data to display,even though  the expression i wrote in both the charts has nothing to do with this cross table fields,but still i am getting this problem.....the problem is with sheet1 and sheet2 looks ok .....

can any one help me plz, plz find the attachment

[Kushal_Chawda]

I am not able to open QV can copy paste the script?

[kunkumnaveen]

what do u mean is my file got corrupted or u got personal edition

[kunkumnaveen]

can any help regarding this requirement plz

[Gysbert_Wassenaar]

Try this expression:

=Aggr(FirstSortedValue(distinct {<ROLE={'EVAL'},SUPCAT=,QUATERS=,YEAR=,name1=>}SUPCAT, -DATE_OF_REVIEW), name1)

[Kushal_Chawda]

I don't have QV in my system

[kunkumnaveen]

where should i try this expression ,i mean in my above pie chart or below in straight table?

[Gysbert_Wassenaar]

In the pie chart. Just add DISTINCT to every FirstSortedValue expression in both charts.

[kunkumnaveen]

i did so,  i am getting nothing out of it, just copy pasted your expression

[kunkumnaveen]

r u working on my file ,if so will u plz send it to me