topic Open Mulitple Sheets with Specific Values in QlikView

Open Mulitple Sheets with Specific Values

Wed, 07 Nov 2012 05:04:16 GMT

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

Re: Open Mulitple Sheets with Specific Values

amars — Wed, 07 Nov 2012 06:45:06 GMT

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.

Re: Open Mulitple Sheets with Specific Values

sushil353 — Wed, 07 Nov 2012 06:51:23 GMT

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

HTH

Sushil

Re: Open Mulitple Sheets with Specific Values

Wed, 07 Nov 2012 07:14:32 GMT

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.

Re: Open Mulitple Sheets with Specific Values

Wed, 07 Nov 2012 07:16:15 GMT

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

Re: Open Mulitple Sheets with Specific Values

Wed, 07 Nov 2012 08:19:18 GMT

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

Thanks

Re: Open Mulitple Sheets with Specific Values

amars — Wed, 07 Nov 2012 11:11:58 GMT

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

Re: Open Mulitple Sheets with Specific Values

Fri, 09 Nov 2012 05:40:12 GMT

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