Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a issue.
How to make a link between table ?
I have three table 1.Start_Date 2.End_date 3. Info_Table
These all table linked like below.
And I have a table like this:
Start_date:
Key_counter Start_time
1 00:00:07
2 23:59:57
End_date:
Key_counter End_time
1 00:00:07
2 00:00:07
InfoTable:
Key_Date Category QvdName
(this is a field used
to generate the start
time and end time)
2012/09/06 23:59:57
2012/09/07 00:00:07 Original Invoice_tab_Aeprod_2012-08.qvd
2012/09/07 00:00:07 Original Invoice_tab_Aeprod_2012-09.qvd
So now issue is If I select the qvd name directly start time and end time list box like this.
But I wan tlike this ..
May be this issue reason is key generation.
And I have attached the script Please find that.
Please help me...!
Thanks in advance..
Regards,
Kabilan K.
Hi,
Check attached file hope it helps you.
Regards,
Jagan.
Hi,
Your sample is add a knowledge to me.
Could u please explain this expression?
if(dimensionality()=1,sum(Value2))
Thanks for Everything.
Regards,
Kabilan K.
Hi,
Dimensionality ( )
Returns the number of dimension columns that have non-aggregation content. i.e. do not contain partial sums or collapsed aggregates.
A typical use is in attribute expressions, when you want to apply different cell formatting depending on aggregation level of data.
This function is only available in charts. For all chart types except pivot table it will return the number of dimensions in all rows except the total, which will be 0.
From QV help file.
Regards,
Jagan.