topic Re: How to create a Button on dashboard for billions millions. in QlikView

How to create a Button on dashboard for billions millions.

Tue, 04 Nov 2014 04:54:08 GMT

Hi,

I've a sales table with total sales column contains more than 8 digit numbers.

User wants to have a simple Buttons for converting into billions millions.

Can anyone help me on this?

suresh_rawat — Tue, 04 Nov 2014 05:09:36 GMT

Hi Muarli,

With the use of variable you can do this.

Please go through the attached qvw, it will solve your problem.

In this QVW i have creat a vVar Variable and use it.

Regards

Suresh Rawat

tresB — Tue, 04 Nov 2014 05:09:56 GMT

See the attached sample qvw.

Anonymous — Tue, 04 Nov 2014 05:20:15 GMT

Hey,

PFA, TO give you basic idea..You can play as you like.

Hope this helps

BR,

Chinna

Tue, 04 Nov 2014 05:32:06 GMT

How to add symbols at the end of the amount ex:- M or B

Tue, 04 Nov 2014 05:32:31 GMT

How to add symbols at the end of the amount ex:- M or B

Thu, 06 Nov 2014 09:58:22 GMT

Hi,

How to apply color to buttons.

For Ex:-

1. If I select Million, then Million button should be Green remaining buttons should be Gray color.

2. If I select Bullion, then Bullion button should be Green remaining buttons should be Gray color.

3. If I select Actual, then All buttons should be should be Gray color.

Help me ??

Thu, 06 Nov 2014 10:09:30 GMT

create 3 buttons

Million, billion,actual

give action for that and in layout tab write condition like if(getfieldselections(millon)>1,1,0) ... like