How to use URL

[#1]

Hi Folks,

I have a data where in the field i have website URLs

Web site topic
q-on.bi

google.com

nasad-it.com

yahoo.com

yahoo.us

and etc

I want to use this url in the application and then from QV open the website how to do this.

Thanks

[#2]

Hi Rob

Thanks for your post, it was exactly what I am looking for. Yet I struggle to get it working as I would like.

I have a table with showing various Dimensions and one column with an expression (value).

Transactio-ID          Value

1234                         500

1235                         750

1236                          39

...

Now for each Transaction ID I have an attachment stored on a shared drive with a supporting PDF document.

Here are the problems I face:

When I add the &'<URL>'&File1 expression to the Transaction-ID Dimension, then it does show the following:

1234<URL>\\Server\Directory\File.pdf as I can't find the Display Option to represent this Dimension as a link.

I then tried to place the link on the expression (value), as I have the Display Option available here. I have added the same part to the expression. Now I get the underlined link, but the value drops to 0 instead of the 500/750/39/etc. The link itself works just fine opening the PDF I want.

If I place a new expression column into the table, using 'Attachment<URL>'&File1 I also get the link, but the value column drops completely to 0.

The value expression is as follows: -Sum({$<Debug={'Actuals'}>} If(AC3='510', BalanceLC))

I don't think the Sum should be a problem, as there is a 1-1 relationship, as we are on the transaction level already.

Any idea how to get it shown in the dimension as link? Or to get the values re-appear?

Thanks

[rwunderlich]

1. Add Tranid as dimension

2. Add an expression that contains the Link: =Tranid  &'<URL>'&File1.

3 Add the Sum(Value) expression.

On the Presentation tab, Hide the Dimension column.

-Rob

[#4]

Thanks Rob

That looks kinda very good, the only thing is, I have now many more transactions shown which don't match the criteria set in the SUM(Value) expression.

I'm using a set expression here Sum({$<Debug={'Actuals'}>} If(AC3='510', BalanceLC)) which only shows "Actuals" (no Budget values) and only shows Transaction from Accounts = 510.

The table now shows transactions which are not related to Account 510 (as value 0) but are still not relevant for my report. How can I use the same set expression for the TranID?

[rwunderlich]

Use only( tranid) in the link expression and include the set expression. You should add AC3={510} in the set.

Rob

[#6]

Hmm, I'm not quite clear I understand.

1. In TranID expression I changed nothing, and in the value expression I added the AC3 to show the following: -Sum({$<Debug={'Actuals'}>+<AC3='510'>} If(AC3='510', BalanceLC))
It still shows rows from all other accounts

2. Whenever I try to add a set to the TranID expression (TransId&'<URL>'&File1), I get an error in the expression

Can I filter for these accounts somewhere in the dimension?

[rwunderlich]

Yes, you could filter the accounts in the dimension like:

aggr({$<Debug={'Actuals'},AC3={'510}'>}Only(TranID), TranId)

In the balance expression the set would be the same.

-Sum({$<Debug={'Actuals'},AC3={'510}'>}  BalanceLC))

Note that your error is in using the Union + with two sets. You actually want one set with a comma between the two modifiers. That's an "AND".

Your URL expression would be:

Only({$<Debug={'Actuals'},AC3={'510}'>} TranID) &'<URL>'&File1

If you filter in the dimension, you should be able to get by with:

TranID) &'<URL>'&File1

assuming there is only one File1 associated with a TranID. If filtering in the dimension, the set would also be unnecessary in the balance expression assuming a TranID contained only one Debug value and one AC3 value. If n doubt, include the set in the expressions as well.

-Rob

[#8]

Dear Rob

I really appreciate your help, yet also this did not do the trick. I keep seeing all those other transactions which are irrelevant. I will go for the simple solution, and just add a list box and filter through that.

Maybe I will try at a later stage to get this going. But at least I have now the link on the transaction, which is already awesome The additional click on the list box is not really that difficult.

Thanks again.

[rwunderlich]

If you can upload a sample qvw, I'll take a look.

-Rob

[#10]

Hi Rob

As it's with real data, I can't really upload this.

[#11]

But I just found out the trick:

When I put =If(Debug='Actuals' AND AC3='510',TransId,Null()) into the Dimension, then it filters all the empty values out and only shows the ones I want