topic Re: Re: Chart Visibility Based on Selected Value? in QlikView

Chart Visibility Based on Selected Value?

Wed, 30 Jul 2014 09:03:02 GMT

Hello Everyone,

Can you please help into this:

I have three buttons, like by city, by region and by country, when i click on the city the table with ( City + col 1 + col 2) should show, same like other buttons. This is fine,

I have one more table like Month+Col1+Col2, This table should show when i select the particular moth in the list box.

Please suggest me how to achieve this based on the selected value in list box.

Thank you in advance

Re: Chart Visibility Based on Selected Value?

MK_QSL — Wed, 30 Jul 2014 09:06:16 GMT

Go to chart properties

Layout tab

Show >> Conditional

Enter below expression

GetSelectedCount(Month)>0

Re: Chart Visibility Based on Selected Value?

aveeeeeee7en — Wed, 30 Jul 2014 09:13:52 GMT

Use this:

=GetSelectedCount(Write The Name of the field you are using in List Box on whose Selction you want to Show the table(Month+Col1+Col2),1)

Your Syntax should be like this:

=GetSelectedCount(FieldName,1)

See the Snapshot to see where to add the conditional Expression:

Regards

Aviral Nag

Re: Chart Visibility Based on Selected Value?

Wed, 30 Jul 2014 09:34:33 GMT

Hello Aviral,

Thanks for your response, I tried it, but i am getting below attached error, Please look into this

Re: Re: Chart Visibility Based on Selected Value?

aveeeeeee7en — Wed, 30 Jul 2014 09:43:11 GMT

See the Attachment.

Re: Chart Visibility Based on Selected Value?

Wed, 30 Jul 2014 09:47:24 GMT

Hi Sreeharhsa,

you have entered the calculation condition on the general tab, instead of the layout tab show condition (shown in Nag's screenshot)

Re: Chart Visibility Based on Selected Value?

Wed, 30 Jul 2014 09:52:18 GMT

I got it Nag, it is working with your reply, Thanks

when i clicked on the month from list box table is showing, but if i click on City button the month chart is not showing,

Please help me in that

Re: Chart Visibility Based on Selected Value?

aveeeeeee7en — Wed, 30 Jul 2014 09:55:06 GMT

You can use Multiple conditions:

GetSelectedCount(Month,1) OR GetSelectedCount(City,1)

Re: Re: Chart Visibility Based on Selected Value?

sasikanth — Wed, 30 Jul 2014 10:20:59 GMT

Hi,

plese find the attached file

i hope it will help you

Re: Chart Visibility Based on Selected Value?

Wed, 30 Jul 2014 10:44:56 GMT

Hello Nag,

I will give you details information: Please help

When i click on the City button: The table is showing like below:

City RoomSold Revenue

XXX 234 1234

When i click on the Country button: The table is showing like below:

City RoomSold Revenue

YY 234 1234

here i used condition like this vviewmode=City to show and hide by button< the chart should show in the same place

Now i have one list box, Lets say Region, if click on any value in the list box, the chart should appear having below values

Month RoomSold Revenue

Jan 123 2343

Feb 123 132431

till this i am done

now the problem is when i click on city my city chart is not showing

Thanks

Re: Chart Visibility Based on Selected Value?

sasikanth — Wed, 30 Jul 2014 11:05:08 GMT

for your butons(City, Country) set an action , like set a variable on selecting button

like v1=1

and

in chart layout condition write like

getSelectedCount(Region,1) OR v1=1

Also in the table presentation show column on condition basis

ues the same one v1=1

then you get according to your requirement

Re: Chart Visibility Based on Selected Value?

aveeeeeee7en — Wed, 30 Jul 2014 11:11:39 GMT

Try this:

=GetSelectedCount(Region,1) AND vviewmode= 'Region'

Re: Re: Chart Visibility Based on Selected Value?

Wed, 30 Jul 2014 13:10:18 GMT

Please look in to that,

i wanted to hide region table when i click on by city button, this is not happening here

Re: Chart Visibility Based on Selected Value?

Thu, 31 Jul 2014 04:22:54 GMT

Any body please look into this

Re: Re: Chart Visibility Based on Selected Value?

PrashantSangle — Thu, 31 Jul 2014 04:35:52 GMT

Hi,

See the attached file.

It will help you

In layout tab condition instead or writing only

vviewmode='Country'

write IF(vviewmode='Country',1,0)

same for all button.

Re: Chart Visibility Based on Selected Value?

Thu, 31 Jul 2014 06:03:46 GMT

I just did it, This is the way i want

Thank you all for your responses