topic Re: requirement in QlikView

requirement

Anonymous — Fri, 30 Jun 2017 12:11:18 GMT

i have 4 buttons ,

what i want is on clicking the total,avg and percentage

so when i click on total and then percentage it shud display the percentage in the chart,and when i den swithc to total from avg the chart shud display me % of total value

with the help of variables,

how to do that

Re: requirement

prieper — Fri, 30 Jun 2017 13:16:05 GMT

Easiest would be to have one button for each calculation and then set a variable (vCalculation) to 1, 2, 3 etc.

As expression you may then enter

= PICK ($(vCalculation), SUM(Cost), AVG(Cost), SUM(Cost)/SUM(TOTAL Cost), AVG(Cost)/AVG(TOTAL Cost))

with different formatting-requirements you may include the formatting as well:

= PICK ($(vCalculation), NUM(SUM(Cost), '#,##0'), ....etc

Peter

Re: requirement

Anonymous — Fri, 30 Jun 2017 13:49:59 GMT

am using a combo chart with multiple expressions

how to put condition in chart as well

Re: requirement

MarcoWedel — Fri, 30 Jun 2017 22:14:53 GMT

please post a sample application to demonstrate

thanks

regards

Marco

Re: requirement

Anonymous — Sun, 02 Jul 2017 10:40:17 GMT

I did it in same way but it's nt working

Re: requirement

Anonymous — Sun, 02 Jul 2017 11:09:37 GMT

Re: requirement

Anonymous — Sun, 02 Jul 2017 11:12:02 GMT

So now if I click on sum and % button both the chart Shud display sum in percentages and if I click on from sum button to AVG with %being selected only the chart Shud display AVG in % ,Wil it be possible using only one variable and how to set the values acrdingly in expressions as well as buttons

Re: requirement

vishsaggi — Sun, 02 Jul 2017 15:38:24 GMT

What you mean by sum in %ges can you show your expected output and your expressions for Sum and Avg.

You can just have two buttons with Sum and Avg. Then using IF condition in your chart expression you can do like the one in attached. I am not sure what your expressions are. Change accordingly.

Re: requirement

Anonymous — Sun, 02 Jul 2017 16:34:20 GMT

Leave abt the expressions,it's just on two butn click chart is displayed when u switch to another keeping one in common ,

Re: requirement

vishsaggi — Sun, 02 Jul 2017 16:49:15 GMT

Sorry did not get you. You have explain a little or share your expected output. Or using the file i attached in my previous reply let me know what you are expecting?.

Re: requirement

Anonymous — Wed, 05 Jul 2017 13:33:51 GMT

Can anyone help for the quick resolution of the said issue

Re: requirement

MarcoWedel — Wed, 05 Jul 2017 20:22:41 GMT

please post a sample application to demonstrate

thanks

regards

Marco

Re: requirement

Anonymous — Thu, 06 Jul 2017 03:51:20 GMT

It's on client machine ,so can't share,but basically I have created two variables and using it in layout tab show conditional but it's not giving the desired output ,button 1,2,3 1 is Shwng sum 2 AVG and 3 %of sum nd AVG now if I click on 1 and den 2 it shud display sum % in the chart and same as wth AVG how I shud set the variables acrsingly

Re: requirement

Anonymous — Mon, 10 Jul 2017 06:18:05 GMT

can anyone please help on the above query ,please ,button toggle ,how to achieve the same.

Re: requirement

balar025 — Mon, 10 Jul 2017 06:42:17 GMT

Hi,

As i understand your requirement , you have 3 buttons,

1) SUM

2) Avg

3) Toggle for actual value or %age.

So, you can 2 variable

vCalculation = 1 for Sum, 2 for Avg

vFormat = 1 for Actual , 2 for %Age

Expression

=Num(Pick(vCalculation,sum(ValueList(10,20,30)),Avg(ValueList(10,20,30))),Pick(vFormat,'#,00;(#,00)','#,00%;(#,00%)'))

Find attachment.

**You can replace value list by your field.

Regards,

Ravi Balar

Re: requirement

Anonymous — Wed, 12 Jul 2017 06:50:59 GMT

thanks,but i cant see any attachment

Re: requirement

Chanty4u — Wed, 12 Jul 2017 09:48:44 GMT

Open this thread in new tab then only you can able to see the attachments.

Re: requirement

Muthu — Wed, 12 Jul 2017 09:57:25 GMT

Once suggestion is in the chart create 3 different expressions for sum avg and percentage.

Create one variable.

In the buttons set variable as 1,2 and 3 for 3 buttons and in the expressions tab enable conditional and set variable as 1,2 and 3 for sum, avg and percentage expressions.

Re: requirement

arvind_patil — Wed, 12 Jul 2017 10:05:40 GMT

Hi Dynamic,

With The help of pick function, you can achieve this:

Pick(Wildmatch(vValue,'SUM','Avg','Toggle for actual value or %age'),

Expression1,

Expression2,

expression3

)

Thanks,

Arvind Patil