topic Re: Condition on Selections in QlikView

Condition on Selections

Fri, 11 Sep 2015 11:56:36 GMT

Hello Friends,

I have one chart over which I want calculation condition. The chart should be visible only after the fulfillment of condition.

Eq.-

Suppose I have following fields -

State	City
Maha	Mum
Pun	Chand

My requirement is when user selects any below combination like

Maha and Mum

Maha and Pun

Mum and Pun

Mum and Chad

Chand and Mum

Chand and Pun ……etc

Then it should display chart respective to above selection but I don’t want to display the chart for below selection

State-Maharashtra

City- Chandi..

If user selects this combination (Maha-Chand) it should give error msg. of calculation condition unfullfilment.

Re: Condition on Selections

kuczynska — Fri, 11 Sep 2015 12:30:28 GMT

Hi,

Can you explain how exactly your data model is build? If State and City are two columns in the same table, you won't be able to make Mum and Pun selection, as they are coming from two different rows and are excluding each other...

But if your data model would be build in a slightly different way (apologies, I really have no idea about the true geography of India...), like the below:

* INLINE [
    State, City
    Maha, Mum
    Pun, Chand
    Maha, Chand
    Pun, Mum
];

You will be able to make all of the mentioned selections:

In that case - please check the attached qvw. You can display a text box for example with any custom message; it's displayed conditionally depending on the value of the variable.

Re: Condition on Selections

Anonymous — Fri, 11 Sep 2015 12:39:41 GMT

Try on Chart Layout condition with your required combination"

say chart1, you want to use for State='maha' and city='mum'

then at layout condition of respective chart use:

=Index(GetFieldSelections(State, ',' ,50),'Maha')<>0 & =Index(GetFieldSelections(City, ',' ,50),'Mum')<>0

where 50 is number of string values of State are allowed rest you can increase or decrease based on your req.

Hope this will help.

Re: Condition on Selections

Fri, 11 Sep 2015 12:41:17 GMT

Hi,

I think, even for the first scenario (State and City are two columns in the same table) there would be a way to achieve selecting data that does not belong to the same row. If you create two Listboxes (State and City) and give each Listbox a different alternate state, you can use the selection from each alternate state in your chart by using Set Analysis functionality.

Cheers,

Claus

Re: Condition on Selections

sudeepkm — Fri, 11 Sep 2015 13:19:19 GMT

if you have data in such a way that same city name appears under different States and your requirement is to select specific City respective to a particular State then you may think of using a drill group that can have both State and City and you can name the group as Location. then you can use the group in a list box.

so when an end user selects a particular State then only Cities belonging to that State will appear in the list box.

It will follow the hierarchy. Snap shot given below.

NOTE: if user selects multiple states then the Cities won't be displayed.

Re: Condition on Selections

Mon, 14 Sep 2015 10:30:30 GMT

Hello friend,

Please check the following snapshot and conditions-

If user selects ''DOM' button in combination with "FORM" button then the Analysis chart should show error message. The chart should be visible for other combinations like DOM - A, Ex - FORM etc except DOM-FORM.

So what condition should i use in Calculation condition