Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

harinikonka
New Contributor II

Switching Charts in Qlik Sense

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

1 Solution

Accepted Solutions
kronzaustin
New Contributor II

Re: Switching Charts in Qlik Sense

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!

8 Replies
Employee
Employee

Re: Switching Charts in Qlik Sense

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

harinikonka
New Contributor II

Re: Switching Charts in Qlik Sense

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
Contributor II

Re: Switching Charts in Qlik Sense

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
Honored Contributor III

Re: Switching Charts in Qlik Sense

harinikonka
New Contributor II

Re: Switching Charts in Qlik Sense

Hi Ishan,

Thank you will try and get back to you.

harinikonka
New Contributor II

Re: Switching Charts in Qlik Sense

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

kronzaustin
New Contributor II

Re: Switching Charts in Qlik Sense

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!

harinikonka
New Contributor II

Re: Switching Charts in Qlik Sense

Hi Austin,

This worked for me. Thank you,

Harini