Switching Charts in Qlik Sense

[Anonymous]

Hello Community,

I’m new to Qlik Sense and there is a requirement for me to convert a QlikView dashboard to Qlik Sense. The QlikView dashboard UI used buttons/trigger actions using variables to switch between charts on the same real estate. I want to replicate same chart functionality in Qlik Sense. I did look into the forum and found some extensions like Sheet navigation, Variable, Tabs for Qlik Sense. Tried Tabs for Qlik Sense Extension but was not able to achieve the functionality I was looking for (it accommodated only one chart in a tab but I need to display 6 charts).  Please can someone help me in achieving the same functionality in Qlik Sense.

I have attached the qvw, for functionality reference, it doesn’t have any data but there are two buttons   “Actual” and “Base”.

By clicking on ‘Actual’ it shows 2 chats  (Actual and Actual), and when  switch to ‘Base’ button  it displays 2 other charts (Base and Base) in the same real estate. I want to achieve this functionality in qlik sense.

So please can someone let me know if that is possible in qlik sense or not?

Thanks,

Harini

[Clever_Anjos]

The best way is using mashups, you get the power to do anything javascript/css can do

More information: https://help.qlik.com/en-US/sense-developer/June2017/Subsystems/Mashups/Content/mashups-introduction...

A lot of examples using mashups: Web Apps from Qlik Sense

[Anonymous]

Hi Clever,

Thank you for the response but  i'm not good at developing extensions and mashups. It will take awhile for me to learn and get going, unfortunately i don't have time to play around with extensions and mashups. I'm looking for an easy way if there is any. Thank you,

Harini

[ishanbhatt]

Hi Harini,

I think you should be able to achieve that functionality using the Variable extension.

Steps:

1. Create one variable.

2. Create condition for dimension or measure

     Ex. if(vTest=1,Measure1,

               if(vTest=2,Measure2)).

That's it. You'll find your desired solution. Hopefully, this'll work for you.

[shraddha_g]

Try extension https://github.com/fadyheiba/ShowHide

[Anonymous]

Hi Ishan,

Thank you will try and get back to you.

[Anonymous]

Thank you Shraddha, will try this and get back to you.

[Anonymous · Accepted solution]

Hi Harini,

You can accomplish this by creating an inline table in the data load editor. Once created, you can reference the field in a List Box (or however you should decide), thus creating your button. In your chart, you would simply use a measure defined in this inline table.

Inline table script would look as follows: (may require some manipulation to get your data in this format)

     //For use with inline table

     SET hideprefix = '%';

          Actual_Base_Table:

               LOAD * Inline [

               %pickmetric, %metric

              'Actual', ACTUAL_FIELD

              'Base', BASE_FIELD

         ];

Field to be used in your List Box (button) object: [gives you the option to select "Actual" or "Base"]

     =%pickmetric

Dimension for your chart(s) can be whatever you decide.

Measure for your chart(s): [toggles the measure of your charts based on what button you have selected]

     =sum($(=%metric))

I hope this helps!

[Anonymous]

Hi Austin,

This worked for me. Thank you,

Harini