Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a input box in that i can able to select the values from 1 to 100 with step 10(i.e, 1,10,20,30,40,50,60,70,80,90,100). I have different fields for carrier table in the edit script. CarrierID is one field among that table. If i select 1 or 10 or 20 etc from the input box. I want to display the last n CarrierID records(i.e n=1 or 10,20) along with other fields of carrier table. How can i do this plz help me.
Hi Boppy,
when you read the data into qv for Carriers do you have one record per carrier?
If so read in the data and add a field like this
rowno() as CarrierIdSeqNbr
this will go from 1 to n depending on how many Carrier records you have read.
at the end of the load put the last CarrierSeqNbr into a variable like this
set vMaxCarrierSeqNbr=peek('CarrierSeqNbr',-1,name of table you just loaded);
you have yourvariable from your drop down box giving how many records you want to see (let's call this vNbrRecordsToDisplay) , you have the maximum record loaded and each Carrier record has a sequential number attached to it.
now use an if clause in your expression
dimension CarrierId
if(CarrierIdSeqNbr>$(vMaxCarrierSeqNbr)-$(vNbrRecordsToDisplay),1)
set supress missing to yes on the presentation tab.
yourchart will show the last n CarrierIds based on your input value.
hope this helps.
Hi PatAgen,
Thanks for responding to my task. I did as u said but it's not working. But one think i didn't understood, u said that at the end of load set the variable by using peek function. What is the use of it. I'm attaching the screen shot of edit script what i did can u check once and give reply whether it is correct or not.
Hi PatAgen,
Thanks for responding to my task. I did as u said but it's not working. But one think i didn't understood, u said that at the end of load set the variable by using peek function. What is the use of it. I'm attaching the screen shot of edit script what i did can u check once and give reply whether it is correct or not.
I can't see your edit. try attaching your qvw file and I'll give it a look over.
The peek function reads one specific record from a given table.
in my answer it i used as the way of recovering th elast Sequential number so as to have in a varaibale the maximum numbre of rows.
Hi Boppy,
I can see the code now! The peek,order should look like this:
peek('CarrierIdSeqNbr',-1,Carrier)
the tablename should be the one in qv not the one in your sql database.
remember to sort your sql query to get your Carrier id in the right order.
ok
the peek command is corrected. are you still having an issue?
Hi PatAgen,
It's not working. Can u attach the qvw file what you have developed.