How do you increment a variable by +1 on a button click?

qlikview
Eddy Jawed picture Eddy Jawed · Oct 10, 2013 · Viewed 7.4k times · Source

Hello kind helpful people,

I am having a major problem in Qlikview. I am just trying to create a button that can increment a variable by +1 each time it is clicked. I thought i could simply write an expression on a button click event but Qlikview is so different. I think it overcomplicates this matter by trying to be too simple. The only thing i can do is 'Set a variable' to a specific value in the button properties.

Does anyone know how to do this?

Many thanks

Eddy

Answer

bdiamante picture bdiamante · Oct 15, 2013

You can do this like you originally tried with an expression in the button action... the key is to make sure you put the = in there so vCount (or whatever your variable is called) gets evaluated first.

enter image description here

Related questions

Counting unique values in a column in pandas dataframe like in Qlik?

If I have a table like this: df = pd.DataFrame({ 'hID': [101, 102, 103, 101, 102, 104, 105, 101], 'dID': [10, 11, 12, 10, 11, 10, 12, 10], 'uID': ['James', 'Henry', 'Abe', 'James', 'Henry', 'Brian', 'Claude', 'James'], 'mID': ['A', 'B', 'A', 'B', 'A', 'A', 'A', 'C'] }) I can do count(distinct hID) in Qlik to come …

Read More
Limit dimension values displayed in QlikView Pivot Table Chart

I have a pivot table chart in QlikView that has a dimension and an expression. The dimension is a column with 5 possible values: 'a','b','c','d','e'. Is there a way to restrict the values to 'a','b' and …

Read More
QlikView - Use a variable into set analysis expression

I've the variable varCurrentYear varCurrentYear = Year(Today()) And I wrote this set analysis expression The result it’s not correct. By the way If the variable is declared in this way varCurrentYear = 2014 The result is correct. Why? Thank's

Read More