topic Re: valueloop issue in QlikView

valueloop issue

Mon, 22 Jun 2015 21:09:44 GMT

Hi experts,
I'm trying to create a kpi metrics table as shown below

Header 1	Header 2
Sales	1000
Quantity	10
Revenue	1100

I tried to uuse valueloop and pick functions but failed to achive desired list.

Below are steps i followed

Create dimension1 : valueloop(1,3)

1st expression: Pick(ValueLoop(1,3),'Sales','Quanitity','Revenue')

2nd expression: pick(valueloop(1,3),sum(sales),sum(Quantity),sum(Revenue))

I'm getting only sum(Sales) value remaining two rows are blank, can you please let me know if I missed anything.

Re: valueloop issue

sunny_talwar — Mon, 22 Jun 2015 21:15:16 GMT

It seems to be working for me:

Re: valueloop issue

Mon, 22 Jun 2015 21:25:38 GMT

Thx Sunindia,

not sure why I'm facing the issue,is it beacuse of varibles I'm using not direct column.

Re: valueloop issue

sunny_talwar — Mon, 22 Jun 2015 21:27:57 GMT

So you are using variables instead of directly using the expressions? But I have seen the variables working also, may be you need to tweak them to make them work. Can you share the file you are working on if its not too big or confidential?

Re: valueloop issue

ramoncova06 — Mon, 22 Jun 2015 22:15:52 GMT

I was having the same issue by having this as a calculated dimension, if you switch it to the expression it works flawlessly

Re: valueloop issue

sunny_talwar — Tue, 23 Jun 2015 02:33:40 GMT

I used variable instead of directly using ValueLoop and it seems to be working well: