Create a Variable toggle without extension

[MK9885]

Hi,

Is there a way to create a variable toggle button in Qlik Sense front end without using extension?

I can create using extension but in Cloud we cannot have extensions installed.

Cloud is very painful to work on...

Why release a half baked Qlik Sense product which is not close to what we have now...

First the struggle was to adjust from Qlik View to Qlik Sense with new UI and missing actions/colors or triggers etc

Now Qlik Sense Enterprise to Cloud which seem to have nothing...

Anyway if anyone know answer to his please...

stalwar1‌

youssefbelloum‌

mto‌

[OmarBenSalem]

You can use inline table.

I mean create an inline table as follow:

load * inline [

IdDimension,Dimension

1,dim1

2,dim2

3,dim3

4,dim4

5,dim5

];

Use this new Dimension field as a list box;

Now, u can show whatever "dimension" u select by a simple if else or pick combinations.

I mean sthing like:

sum(if(IdDimension=1,YourFirstActualDimension, if(IdDimension=2,YourSecondActualDimension)) )

Hope this would help

[MK9885]

Hi Daniel,

Qlik Sense Cloud doesn't have capability to install extensions or widgets.

[MK9885]

stalwar1‌

This scenario can also be done in Qlik View.

Ex: Just need to create a toggle view without using button or actions

Thanks.

[OmarBenSalem]

Suppose I have 3 measures:

sum(CA)

sum(Quantity)

sum(Marge)

And I want to have all 3 measures in the same graphic.

You can add them as alternative measures as you're doing.

ANother way is to create an inline table in the script:

Let's call it:

Measures:

load * inline [

Measure

CA

QUANTITY

MARGE

];

Now, in our graphic we only have to use one measure:

sum(if(Measure='CA',

CA,

if(Measure='QUANTITY',

[Quantité] ,

if(Measure='MARGE',

Marge ))))

Add the new created field Measure as a filter object, and when you select a value, your measure will change with your selection:

Example:

I select CA: I get sum(CA) as a measure in my bar chart

I select Marge:(I get sum(marge) as a measure of my bar chart

Hope this helps

[MK9885]

Ok, I'll look into this...

A. I need to merge 5 dimensions in a single dimensions with values as Open, Closed, Pending

These 5 dimensions are used as measures (Numeric) values in these

If I select Open, it should show me all the values related to Open only and so on...

[shraddha_g]

answer given by Omar will work as per your requirement.

[MK9885]

Wouldn't this create synthetic keys?

Since we are writing same measures again in Inline table?

Or it is just an Island table as Anton has suggested?

Would be helpful if you can upload a sample?

Please note, I'm using Set function for my expression with a week filter in it

sum({<Week={"$(='>=' & date(today()-84))"}>} [$(vHRVersion)_Hours] )

Thanks.

[OmarBenSalem]

if u have 3 dimensions containing all 2 values (open, close)

dim 1 : open, close

dim 2 : open, close

dim3 : open, close

How do u want to select open in every dimension at the same time?

Suppose, we could do that, how will u integrate the 3 in ONE EXPRESSION?

I can't see how this would work unless it's a count.

I mean

count(dim1) + count(dim2) + count(dim3) => when u select open in the 3 dimensions, u'll how many open counts u have...

Ur final outcome is not clear for me..

[OmarBenSalem]

It's an island table that does not have anything to do with ur model; we'll just be using it for selection; depends on what value u select from ur new created field (of the island inline table), u associate this selection to the real actual dimension u want to show.

[avkeep01]

This is the first example in my QVF. I used a Pick function instead because it is a bit faster. An if function calculates all the options, the pick function only the one choossen.