Dynamic bar chart

[Sagar082]

Hi everyone,

Greeting for the day. I have created bar chart of transaction on monthly, quarterly and weekly. Also, has flexibility to change measures. 

At present I used alternative dimensions and measures to create it. 

But, I would like to create buttons for month, weeks and quarters at dimension level and no. of transaction and amount at measurement level.

Would like to know how I can like these buttons, so if user select month and no. of transaction then he would see respective bar chart.

But if user select weeks and amount then only respective chart should be visible. 

I am keen to present one chart at a time, so other chart should hide.

Please provide your valuable suggestions.

In case you have query then write back.

Thanking you in anticipation.

Regards,

Sagar.

[_ylc]

What you can do is the ff:

1. Create variables

•  vSelectedDimension
• vSelectedMeasure
• vSelectedDimLabel (label purposes)
• vSelectedMeasureLabel (label purposes)

2. Create your buttons

• Year, Month, Quarter, Weekly,..
• Amount, No of Transactions,..

3. In your button,

• for Dimension -> set the variable value based on the fieldname.

e.g. for Year button, you set the value to Year (take note that this should be what your field for Year is)

Do the setup for the rest of your buttons.

• for Measures, set the value to your formula. E.g. SUM(SALES)

4. In your bar chart:

• dimension value: =$(vSelectionDimension)

  
• Measure Value:  =$(vSelectedMeasure)

[Sagar082]

Hi,

Greeting of the day. Thank you for your reply. Since, I am new to Qliksense, I may have many doubts. Please bear with me.

I would like to know, which button you are creating is it variable or Menu bar?

I could not get pop-up window of action anywhere?

I am sorry If my question doesn't sound well.

Regards,

Sagar.

[_ylc]

May I know which Qlik Sense version are you using?

[Sagar082]

Hi,

Greeting for the day. Thank you reply. I am using Qliksense June 2019, qliksenseserver: 13.3.2.2

Regards,

Sagar.

[_ylc]

Can you check under Custom Objects under Qlik Dashboard Bundle. There's a button object there you can use.