topic How to display the data based on Input value in QlikView

How to display the data based on Input value

jagannalla — Thu, 24 Mar 2011 09:48:03 GMT

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.

How to display the data based on Input value

pat_agen — Thu, 24 Mar 2011 10:19:17 GMT

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.

How to display the data based on Input value

jagannalla — Thu, 24 Mar 2011 13:57:55 GMT

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.

How to display the data based on Input value

jagannalla — Thu, 24 Mar 2011 14:00:43 GMT

How to display the data based on Input value

pat_agen — Thu, 24 Mar 2011 14:00:47 GMT

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.

How to display the data based on Input value

jagannalla — Thu, 24 Mar 2011 14:03:45 GMT

How to display the data based on Input value

pat_agen — Thu, 24 Mar 2011 14:09:24 GMT

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.

How to display the data based on Input value

pat_agen — Thu, 24 Mar 2011 14:10:56 GMT

the peek command is corrected. are you still having an issue?

How to display the data based on Input value

jagannalla — Fri, 25 Mar 2011 16:52:54 GMT

Hi PatAgen,

It's not working. Can u attach the qvw file what you have developed.