Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Toggle expression in pivot table

I'm new to the community and QlikView.  I searched but unfortunately I didn't find exactly what I was looking for. 

I have a model with a pivot table that compares expressions that are typically actual, budget and forecast.  So for any one table we compare, actual to budget, or forecast to actual or forecast to budget.  Is there a way I can dynamically change the columns between actual, budget or forecast. 

I was using set analysis.  Below is the one for budget:

(Sum({$<balance_code={'BUDGET'}>} Amounts))

So I basically want 'Budget' to toggle.  I think I can do it with a button, but ideally I would like a drop box in the pivot table.  Not sure if QlikView can do the later.

1 Solution

Accepted Solutions
MVP
MVP

Re: Toggle expression in pivot table

Hi,

You can try this by using Expressions grouping which is similar to "Cyclic Group" for dimensions.  You can create expression grouping in Expressions tab of chart by clicking "Group" button.

Hope this helps you.

Regards,

Jagan.

4 Replies
phaneendra_kunc
Valued Contributor III

Re: Toggle expression in pivot table

Hi

See ATTACHED if this helps.

Create a inline table with those 3 fields ( and use that field in your expression and you can keep a list box/multi box on top of your pivot table.

Regards

Phani

MVP
MVP

Re: Toggle expression in pivot table

Hi,

You can try this by using Expressions grouping which is similar to "Cyclic Group" for dimensions.  You can create expression grouping in Expressions tab of chart by clicking "Group" button.

Hope this helps you.

Regards,

Jagan.

nilesh_gangurde
Valued Contributor

Re: Toggle expression in pivot table

Hi lidojuagon,

You can can load the inline table.

Make three different table using the three expression.

And put the condition in chart that it will show only one chart at a time other two charts are invisible.

when u select the value from the list box accordingly the corresponding chart gets visible.

Hope this helps !

Regards,

Nilesh Gangurde

Not applicable

Re: Toggle expression in pivot table

Using the grouped expression function is there a way to dynamically update my variance column to subtract  the two columns.  In other words, if I select actual in one column and budget in the next it should calc the variance between the two, but if I change actual to forecast it should update the variance.  Seems like there should be a way to name your grouped expression.

Community Browser