Open Mulitple Sheets with Specific Values

[#1]

I am at my Intial stages of exploring QlikView 11.
I have a List Box having Categories on the Main Page. ListBox is multi Select.

1) Action

2) Animation

What I have already done :
1) On selecting "Action" from ListBox, a New sheet opens with the Name of CategoryName i.e "Action".

2) On selecting "Animation" from ListBox, a New sheet opens with the Name of CategoryName i.e "Animation".

3) On selecting both: "Action,Animation", both sheet opens, but CategoryName passed is "Action,Animation", which is obvious. BUT I DO NOT WANT THIS.

This is done through setting value of single common variable : vCategorySelected.

What I want :

3) On selecting CategoryName : "Action,Animation", Both sheets must open.

BUT CategoryName= "Action" should only be passed to Action sheet and CategoryName = "Animation" must only be passed to Animation Sheet.

I hope I am able to convey my requirement.

Thanks

[amars]

Hi Angad,

In that case can you put conditions in your expressions for the chart's to restrict the data.

i.e. on Actions tab in chart Expression use condition like If(CategoryName = 'Actions'

same way in you Animations tab as well.

Thanks.

[sushil353]

Hi

You can write macro and have different variable for each list box.

HTH

Sushil

[#4]

Hi amars,

Thanks for your response, yes that did work for Chart Expressions. But what if I am having a TableBox on "Action" sheet using the CategoryName, how would I use it there. Since if i use it in the calculation condition of TableBox, then the CategoryName is already being set to "Action, Animation".

And if use the If condition in calculation condition it gives error: condition unfulfilled.

[#5]

Hello Sushil,

Thanks for your response, since i am still a beginner, I am not aware much about macros, is it possible that if you could guide me through steps. ?

Thanks

Angad

[#6]

By Adding hardcoded If in each expresson, I was able to achieve this by using Straight Table instead of Table Box.

Thanks

[amars]

Hi Angad,

Sorry for late reply was busy with some work.

For Tables what you can do is you can create a field in your script like

IF(CategoryName = 'Actions', CategoryName) as CategoryName1

Now this will hold only "Actions" as the value for other values CategoryName1 will be NULL.

Now to supress the records in ur Table where CategoryName is not "Actions" simply add the Field CategoryName1 and select the property Omit Row When Field is NULL.

Hope this helps.

Thanks

Amar

[#8]

Thanks amars for your response, I have noted down this approach for if i use Table Box in future. For now I handled this by using the Straight Table instead.

Thanks

Angad