topic Re: How to Solve this? in QlikView

How to Solve this?

Thu, 04 Oct 2012 13:04:07 GMT

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.

Re: How to Solve this?

jagan — Fri, 05 Oct 2012 11:27:23 GMT

Hi,

Check attached file hope it helps you.

Regards,

Jagan.

Re: How to Solve this?

Fri, 05 Oct 2012 11:54:57 GMT

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.

Re: How to Solve this?

jagan — Fri, 05 Oct 2012 12:16:47 GMT

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.