Iter number dimension

[Anonymous]

Colleagues, good day!

I have some problem with creating special dimension and work with it^

1.In pivot table i want to create dimension, which must have values from 1 to N (N - value from input box.)

2. In expression i need get value from this dimension &  '_2016'

For example, if i set value in inputbox 6, i must get sum result pivot report:

Dimension	Get Value from dimension
1	1_2016
2	2_2016
3	3_2016
4	4_2016
5	5_2016
6	6_2016

test model in attachment.

Thanks.

[Clever_Anjos]

Try ValueLoop(1,v1) as dimension

[Clever_Anjos]

[sunny_talwar · Accepted solution]

May be this as dimension to get _2016 attached to all the rows:

=ValueLoop(1, v1) & '_2016'

[santiago_respane]

Hi,

if i assume right, you can achieve that with set analysis:

=SUM({<f1={">=1<=$(v1)"}>} f3)

This will filter your dimensions in your table.

Find sample attached.

Please let me know id this helps.

Kind regards,

[Anonymous]

Thanks!

[Anonymous]

Thanks!

[Anonymous]

Thanks!

[sunny_talwar]

I think you should be at least mark Clever‌ as helpful, if not correct. I just took his idea and put it in a way you wanted to see. I really appreciate your time on this

Qlik Community Tip: Marking Replies as Correct or Helpful