topic Re: hi explain one more req? in QlikView

hi explain one more req?

gkcchowdary — Mon, 24 Aug 2015 13:19:09 GMT

i have one table like below

table1:

year,month,sales,area

2014,1,100,hyderabad

2014,2,200,bangalore

upto

2014,12,1200,mumbai

so my requirement is first create bar chart and starting no chart appear once i selected any one month it will display

first month sales and i selected 4 th month it will disply 4 th month sales

i selected any two months that two months sales display and more than two months selected chart hide

so any one month or two months selected chart appear if not selected chart hide,how?

Re: hi explain one more req?

veeranj — Mon, 24 Aug 2015 13:23:59 GMT

Hi Chaitanya,

In the layout tab, under show Section, give the Condition as GetSelectedCount(Month)<=2

When you select more that one month,the chart will get hidden .

Thanks,

Anjee

Re: hi explain one more req?

kkkumar82 — Mon, 24 Aug 2015 13:30:03 GMT

Hi ,

Please find the attached qvw file , hope it may help you.

Thanks

Kiran Kumar

Re: hi explain one more req?

karthikeyan1504 — Mon, 24 Aug 2015 13:30:23 GMT

Hi,

Go to chart properties -> layout.

In show conditional, enter the expression of getselectedcount(month)=1 or getselectedcount(month)=2

Warm Regards,

Karthikeyan.

Re: hi explain one more req?

kkkumar82 — Mon, 24 Aug 2015 13:34:03 GMT

Sorry ,

I have used calculation condition and error messages in general tab.

Thanks

Re: hi explain one more req?

avinashelite — Mon, 24 Aug 2015 13:38:43 GMT

please find the attached e.g . You can achieve it two ways ..

1. Go to>Chart Properties >Layout > show>Conditional >

if(GetSelectedCount(Dimension)>0 and GetSelectedCount(Dimension)<=2,1,0)

2. Chart Properties >General >Calculation Condition >

if(GetSelectedCount(Dimension)>0 and GetSelectedCount(Dimension)<=2,1,0)

In the example select the dimension you will get the idea

Re: hi explain one more req?

Mon, 24 Aug 2015 14:03:09 GMT

Hi. May be like this.