Gauge chart with toggle selection of YTD,MTD,QTD,WTD

[#1]

Hi guys,

I want to display YTD,MTD,QTD,WTD in single Gauge chart by using toggle selection.Expression for the gague chart is YTD/Previous YTD,QTD/Previous QTD..so on.

Can anyone help me on that.

Thanks

siva

[sorrakis01]

Hi,

Maybe this one can help you

https://community.qlik.com/docs/DOC-6163

Regards

[Anonymous]

Hi siva,

On script load an inline table with the options do you want, with an numeric field, like this:

Options:

LOAD * inline [

     OptCode,      OptDesc

     1,                    YTD

     2,                    QTD

     ...

];

Then, on your Gauge Chart, on Expressión:

Pick(OptCode,

     Expr for YTD,

     Expr for QTD,

...)

Regards!

[#4]

Thanks Capella,

is there any possibility of using variables in expression in gauge chart.

[Anonymous]

Yes, you can use all vars do you want

Regards!!

[#6]

Thanks Capella,

I have one more doubut..

Can you please help me

i have items,customers,vendors and buyers in my Qvw,i want to know the which item /customer/vendor/buyer are active status

Support filter by active status on: Customer, Item, Vendor, and Buyer

can ypu please help me on that

Thanks

Siva

[Anonymous]

Hi siva,

What do you mean with Active Status? Selected Items? Or do you have a flag to indicate wich items are active?

Thanks!

[#8]

Hi Capella,

I want to know the which items/vendors/buyers/customers are active?,means which one will working and which one working currently which are working that will be considerd as active or not working means inactive..

If we select some items which items are in active status,which items are not active that i want to know

..?

can you please help me on that..

Thanks

siva

[Anonymous]

Hi siva,

If you have a flag, then:

Active -> With set analysis: {<Status={'Active'}>}

Non Active -> With Set analysis: {<Status-={'Active'}>}

How do you detect Active and Non Active items? With Flag? With Dates?

Regards!

[#10]

Hi Capella,

Thanks your answer.

Flags only