topic Re: Need help on field name in QlikView

Need help on field name

nagarjuna_kotha — Wed, 29 Apr 2015 12:58:27 GMT

Hi all,

I have one list box like below attached file. I want to show that list box name without doing any selections.How can we achieve that.

Kindly give me solutions ASAP.

Plz Find below attached file.

Re: Need help on field name

CELAMBARASAN — Wed, 29 Apr 2015 13:02:45 GMT

Requirement is not clear. Describe your problem with more explanation for the getting better responses.

Re: Need help on field name

buzzy996 — Wed, 29 Apr 2015 13:06:26 GMT

try this,

Re: Need help on field name

nagarjuna_kotha — Wed, 29 Apr 2015 13:15:05 GMT

No,Not like that shiva. I want that Entaire name in text box without doing any selections.

Thanks in Advance

Re: Need help on field name

buzzy996 — Wed, 29 Apr 2015 13:17:45 GMT

i think just u can put ur list box field in ur text,tht will give the expected result..i think so.

else pls share ur app with expected output?

Re: Need help on field name

petter — Wed, 29 Apr 2015 14:00:01 GMT

I guess this is what you are looking for:

Re: Need help on field name

robert_mika — Wed, 29 Apr 2015 14:00:58 GMT

Maybe:

Create a group-->Add only this field to this group.

The in textbox:

=GetCurrentField(Amount)

In my example the Field and Group names are the same but you can use diffrent

Re: Need help on field name

jagan — Wed, 29 Apr 2015 14:56:19 GMT

Hi Nagarjuna,

If you attach sample data then it would be easier to give the solution.

Regards,

jagan.

Re: Need help on field name

petter — Wed, 29 Apr 2015 15:09:13 GMT

The sample data is already included in my suggestion for a solution - since it was easy to Google to find it... so it is simply a LOAD .... FROM [http://.....];

LOAD
@1 AS DieselPriceText
FROM
[http://www.mypetrolprice.com/3/Diesel-price-in-Mumbai]
(html, utf8, no labels, table is @10)
WHERE @1 Like 'Mumbai*';

Re: Need help on field name

jagan — Thu, 30 Apr 2015 06:23:23 GMT

Hi Nagarjuna,

Try like this

Sample Script;

LOAD

@1 AS DieselPriceText,

Date(Date#(Mid(@1, Index(@1, ',') + 2), 'MMMM D, YYYY')) AS Date,

Mid(@1, 1,

Index(@1, 'Rs/Ltr') + 6) AS Price,

Mid(@1, Index(@1, ':') + 2) AS DATE_FORMAT

FROM

[mypetrolprice.com/3/Diesel-price-in-Mumbai]

(html, utf8, no labels, table is @10)

WHERE @1 Like 'Mumbai*';

Expression for List box:

=FirstSortedValue(Price, -Date) & ' Most recent changed date : ' & FirstSortedValue(DATE_FORMAT, -Date)

Please find attached file for solution.

Regards,

Jagan.

Re: Need help on field name

nagarjuna_kotha — Thu, 30 Apr 2015 06:37:43 GMT

Re: Need help on field name

nagarjuna_kotha — Thu, 30 Apr 2015 06:39:59 GMT

Thank jagan,Good job.

Regards,

Nagarjuna