Help plz

[#1]

I have a drop down list in my qlikview application that contains 3 values (lose, wine, new) how do i edit the script so that only the data with lose (for example) values are available without the need for a drop down selection box.

[#2]

Hi,

try this!

SET mVar = 'lose';

LOAD
 myField1,
 myField2,
 ....
FROM myTable
WHERE myField1 = $(mVar);

[#3]

My biggest problem is that the application has a different tab for each category (lose,win,new) so in each tab I only want to see the relivent records. Every piece of ciode I have seen seem to be removing the other records from the whole application.

Is there any way to create a new qvd for each and then call on them at the designated tab's

[brenner_martina]

Hi,

you can enter an action to select the right content for each tab, look at sheet properties for triggers, Add Action, Add, Selection: Select in Field

[montubhardwaj]

Actions will be the best way to achieve this. The attached will help you. Here, Main sheet will always show you Jan data, Sheet1 will show you Feb data and Sheet 3 will show you Mar data. So this way you dont have to have Selection box. Hope that wa shelpful.

[montubhardwaj · Accepted solution]

Actions will be the best way to achieve this. The attached will help you. Here, Main sheet will always show you Jan data, Sheet1 will show you Feb data and Sheet 3 will show you Mar data. So this way you dont have to have Selection box. Hope that was helpful.

[#7]

That definately helps alot ,Thanks .

but is their anyway the other records can be removed on each page so that the user can't change the selection from lose to win

[montubhardwaj]

Yes. you can do that. Go to properties of the list box ->General tab -> and then check Read only option. That will not allow anyone to make any selections in the selection box.

[#9]

You can still change the selection by selecting greyed out data from another field .

Sorry for bein a pain lol

[montubhardwaj]

Yes! you are right. If you select in other fields, this value will change and this is the way QV works(associative logic). Because you are not going to have any selection box there, so i think you should'nt be worrying about that .....

Hope I am right ....LoL