topic Re: Iter number dimension in QlikView

Iter number dimension

Anonymous — Tue, 31 May 2016 14:02:33 GMT

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.

Re: Iter number dimension

Clever_Anjos — Tue, 31 May 2016 14:08:31 GMT

Try ValueLoop(1,v1) as dimension

Re: Iter number dimension

Clever_Anjos — Tue, 31 May 2016 14:09:03 GMT

Re: Iter number dimension

sunny_talwar — Tue, 31 May 2016 14:12:53 GMT

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

=ValueLoop(1, v1) & '_2016'

Re: Iter number dimension

santiago_respane — Tue, 31 May 2016 14:22:38 GMT

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,

Re: Iter number dimension

Anonymous — Wed, 01 Jun 2016 07:39:23 GMT

Thanks!

Re: Iter number dimension

Anonymous — Wed, 01 Jun 2016 07:39:27 GMT

Thanks!

Re: Iter number dimension

Anonymous — Wed, 01 Jun 2016 07:39:34 GMT

Thanks!

Re: Iter number dimension

sunny_talwar — Wed, 01 Jun 2016 11:00:12 GMT

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