topic AW:Re: AW:Help plz in QlikView

Help plz

Thu, 28 Apr 2011 08:57:51 GMT

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.

AW:Help plz

Thu, 28 Apr 2011 09:03:20 GMT

Hi,

try this!


SET mVar = 'lose';

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

AW:Help plz

Thu, 28 Apr 2011 09:09:00 GMT

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

AW:Re: AW:Help plz

brenner_martina — Thu, 28 Apr 2011 09:12:26 GMT

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

AW:Re: AW:Help plz

montubhardwaj — Thu, 28 Apr 2011 09:45:47 GMT

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.

AW:Re: AW:Help plz

montubhardwaj — Thu, 28 Apr 2011 09:45:55 GMT

AW:Re: AW:Help plz

Thu, 28 Apr 2011 10:06:23 GMT

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

AW:Re: AW:Help plz

montubhardwaj — Thu, 28 Apr 2011 10:16:07 GMT

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.

AW:Re: AW:Help plz

Thu, 28 Apr 2011 10:49:03 GMT

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

Sorry for bein a pain lol

AW:Re: AW:Help plz

montubhardwaj — Thu, 28 Apr 2011 11:15:35 GMT

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