Total qualifier with Only function

[#1]

Hi guys,

Is it possible to use Total qualifier with Only function?

i have a situation where I need to show Dates for my two dimensions.

Something like this...

Table1:

ID  LinkedID

1    5

4    7

Table 2:

ID    Date

1    01/02/2012

4    03/05/2014

5    08/09/2013

7    08/07/2015

Now the chart should be like this:

ID      LinkedID      DateforID      DateForLinkedID

1        5                01/02/2012    08/09/2013

4        7              03/05/2014    08/07/2015

DateforID can be shown by the simple expression 'Table2:Date.

but DateForLinkedID I need to ignore the ID so i am trying to use only(Total<ID>Date) but it gives me dates for ID and not for LinkedID.

So it looks like this which is not what I want:

ID      LinkedID      DateforID      DateForLinkedID

1        5                01/02/2012     01/02/2012

4        7              03/05/2014       03/05/2014

Any suggestions?

Regards,

Saurabh

[#2]

Can you please give me little explanation that why is it working the way it is working?

[#3]

i think i understand how it works.

It has one issue though...

What if there are more than one linked associated with ID?

This Pick match works on the unique value of ID to choose the Only(Total<>) expression but if the iD is not unique then it will not work.

Do you have suggestion for that?

[sunny_talwar]

I kind of understand what you mean, but will better understand your question if you can provide a sample of what you are trying to say. Can you provide a sample?

Best,

Sunny

[#5]

I have made slight modifications to the expression and the data to the file you had attached before.

It will help you understand what do I want to say.

[sunny_talwar]

Slight tweak in the script (not sure if you want to make that also or not), but this might work for you:

Table1:

LOAD *,

  ID&LinkedID as Join;

LOAD * INLINE [

    ID, LinkedID

    1, 5

    4, 7

    1, 8

];

Table2:

LOAD * INLINE [

    ID, Date

    1, 01/02/2012

    4, 03/05/2014

    5, 08/09/2013

    7, 08/07/2015

    8, 07/06/2010

];

Find attached the application for the front end expressions.

Best,

Sunny

[#7]

It is a nice trick but my problem is that I cannot change the scripts.

But it gives some idea...

Thanks for that...
BTW..do you think that it is not possible without changing the scripts?

[sunny_talwar]

From the limited knowledge I have gathered over years, I don't think there is a way, but I may be wrong and someone else might have a better answer for you.

But I am 100% sure that doing it in the script is the best option if you can somehow make that happen.

HTH

Best,

Sunny

[#9]

Thanks Sunny,

Even though it was not a full solution i learnt few things from you.

[sunny_talwar]

Yup

We all are learning from each other. I am glad you learnt something from me

Best,

Sunny

[sunny_talwar · Accepted solution]

Hey Saurabh Ramya‌

Check this out (PFA)

May be this is a better option for you.

Best,

Sunny