Pass parameter from mutilbox or listbox value to the table or pivot

[#1]

Hi ,

I using SQL script to create the Qlikview report .

Select Dept,Business,Account from Test_table where Version='FY13 SepOL'

and Month='201312'

So here i wanted the filter condition to be passed dynamically meaning if the user selects another version and month from either list box or multibox created for Version or Month  that should hit the query and get the data for the report .Is this possible in Qlikview ?

Please share your ideas.

Thanks,

Mayuri

[Anonymous]

You Cannot hit the DB and get values every time the users makes some selections. You have to load the complete table in Qlikview and in your charts, you need use specific conditions to show values only for the particular requirement.

And in your case if you are showing a sales then you need to use the conditions which will defined the range on which the data is displayed.

Hope that helps.

-Aadil

[#3]

Yes  I know it is not possible to hit the DB but my req is like i want to get the values from listbox or mutilbox for version or month then take that value(current selection in to a variable ) use that  in the sql script to calculate some conditions and join with other tables to get the data .How would i achieve that .

Thanks

[Anonymous]

Please check attached and see if that helps.

After the variable is set, you can reload the document and it would get data only for that particular condition.

Hope i have understood your issue here..

-Aadil

[marcus_malinow]

Hi Mayuri,

I'd suggest loading the entire dataset into your .qvw, using a query such as

Select Dept,Business,Account, Version,Month  from Test_table

Then simply have listboxes to allow the user to select Version and Month.

If you display the other fields in a chart, then perhaps put a calculation condition on it, based on GetSelectedCount(Version) = 1 and GetSelectedCount(Month) = 1

Hope this helps,

Marcus

[Gysbert_Wassenaar]

Unless you're dealing with massive amounts of source data the recommended way is to load all the data into Qlikview and simply let the end user make selections to filter the data.

If that's really really seriously not practical you can try using Direct Discovery or Partial Reload.