Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Need help on field name

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.

Field name.PNG

1 Solution

Accepted Solutions
jagan
Partner - Champion III
Partner - Champion III

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.

View solution in original post

11 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

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

buzzy996
Master II
Master II

try this,na.PNG

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II
Author

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

Thanks in Advance

buzzy996
Master II
Master II

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?

petter
Partner - Champion III
Partner - Champion III

I guess this is what you are looking for:

2015-04-29 #2.PNG

2015-04-29 #1.PNG

robert_mika
Master III
Master III

Maybe:

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

29-Apr-15 2-59-28 PM.jpg

The in textbox:

=GetCurrentField(Amount)

29-Apr-15 2-58-31 PM.jpg

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

jagan
Partner - Champion III
Partner - Champion III

Hi Nagarjuna,

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

Regards,

jagan.

petter
Partner - Champion III
Partner - Champion III

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*';

jagan
Partner - Champion III
Partner - Champion III

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.