Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Solve this?

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.

Capture.PNG

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.

Capture1.PNG


But I wan tlike this ..

Capture2.PNG

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.

3 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Check attached file hope it helps you.

Regards,

Jagan.

Not applicable
Author

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.

jagan
Luminary Alumni
Luminary Alumni

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.