topic Re: Conditional Question. in QlikView

Conditional Question.

MuraliPrasath — Tue, 28 Jul 2015 05:18:30 GMT

Hi,

I've a Pie-Chart. If I select Pie-Chart dimension field, then it should take me to the SH04 sheet automatically, this is a detailed tab.

How to achieve this? How to write conditional statement on Dimension?

Re: Conditional Question.

MuraliPrasath — Tue, 28 Jul 2015 05:40:59 GMT

On selection CarFamily is should take me to the SH04 Sheet. How to achieve this? How to write a condition?

Re: Conditional Question.

robert_mika — Tue, 28 Jul 2015 05:42:34 GMT

If the second the only way is to add

a transparent button or Textbox which does exactly this action and put it over it the chart.

Create TextBox

Set Transparency to 100%

Then go to Actions-Add --Action Type-layout-ActiveSheet

In SheetID add SH04

Re: Conditional Question.

avinashelite — Tue, 28 Jul 2015 05:45:30 GMT

Try like:

1.Set a variable to check whether dimension has been selected of not, like:

getfieldselections(your_fieldname)

2.Go to documents Triggers > on the variable action >set the activation of the desired sheet

hope this helps you

Re: Conditional Question.

Kushal_Chawda — Tue, 28 Jul 2015 05:45:45 GMT

!Hi,

You can use field event trigger for this.

Go to document properties -> Triggers-> Field event trigger

Select CarFamily-> Onselect-> Activate sheet-

Re: Conditional Question.

vikasmahajan — Tue, 28 Jul 2015 05:46:24 GMT

Check if there is relation bewteen your data you can create drill and put into chart so that when you click on 2FICE 4PAS -> then pie chart will show further level in pie-Chart.

HTH

Vikas