topic Re: Conditional Display of values in BAR chart in QlikView

Conditional Display of values in BAR chart

Thu, 10 Oct 2013 04:17:11 GMT

Hi All,

I have a bar chart(let say X),in which each month data will be uploaded(ie..Jan,feb,Mar...) for different Customers,for that i would lik to add some conditions like(It should consider the expressions from other 3 charts),..ie..let say the charts be A,B,C it also contains information based on months.IF the expression, A=0 and B=0 and C=0 then X should display '100' else it should calculate the expression used in it.

Since the information is displayed based on months all months it should consider,sometimes it may be Jan month,feb month...etc...

Is there any possible way to achieve this.

Thank You.

Re: Conditional Display of values in BAR chart

saumyashah90 — Thu, 10 Oct 2013 04:21:25 GMT

hey,

I dont know if got it correct.

But like der are 4 expression in your chart.

name A,B,C,Xthen you can youse name of the expression given as a field name

Same as

under expression name X you can write if(=0 and =0,100)

Re: Conditional Display of values in BAR chart

sujeetsingh — Thu, 10 Oct 2013 04:25:55 GMT

Reena ,it seems i am not able to get what you exactly want ?

Can you please paste a sample or explain in more words.

Re: Conditional Display of values in BAR chart

Thu, 10 Oct 2013 05:03:34 GMT

Hi,

When U check on the attached file, I have 3 Charts A,B,C, for that when u analyse for all three charts for the month of 'Aug' the values are Zero for a particular customer. Then for the particular month(AUG) the 4th chart 'X' should display the value 100. for rest all months it should display the expression used in it(X).

This may Vary based on customers, for some customers this conditions wont satisfy...for some it may be May, for some june..

Re: Conditional Display of values in BAR chart

Thu, 10 Oct 2013 05:08:28 GMT

Re: Conditional Display of values in BAR chart

saumyashah90 — Thu, 10 Oct 2013 05:20:27 GMT

A,B,C are three charts for different customers?

Re: Conditional Display of values in BAR chart

Thu, 10 Oct 2013 05:27:52 GMT

for same customers... 3 different Expressions

Re: Conditional Display of values in BAR chart

Thu, 10 Oct 2013 05:29:44 GMT

Hi,

please check the above Sample graph.

Re: Conditional Display of values in BAR chart

saumyashah90 — Thu, 10 Oct 2013 05:34:59 GMT

You put 3 expression with name A,B,C in X chart and then uncheck enable for A,B,C

After that use A, B, C as field and you can achieve it