topic Re: Dimension expression shows repetitive values. in QlikView

Dimension expression shows repetitive values.

Wed, 18 Sep 2013 07:20:55 GMT

Time_interval	Year 2011	Year 2012
4:30 - 5:00	24	18
5:00 - 5:30	2,975	3,504
5.30 - 6.00	6,933	10,307
6.00 - 6.30	9,154	10,359
6.30 - 7.00	22,365	18,003
7.00 - 7.30	19,416	131,800

Hello, I have three dimensions. Time_interval, ArticleNo and Year. I need straight table as above. I'm not getting desired output as above, when i use the below query for Year.

Year 2011 expression -------- =Aggr(NumericCount(ArticleNo), Time_interval, Year=2011)

Year 2012 expression -------- =Aggr(NumericCount(ArticleNo), Time_interval, Year=2012)

I somehow gets the answers, but i get repetitive Time_interval values. like below. Please help me. Thankyou.

Time_interval	Year 2011	Year 2012
4:30 - 5:00	24	18
4:30 - 5:00	2,975	3,504
5.30 - 6.00	6,933	10,307
5.30 - 6.00	9,154	10,359
6.00 - 6.30	22,365	18,003
6.00 - 6.30	19,416	131,800

Re: Dimension expression shows repetitive values.

kangaroomac — Wed, 18 Sep 2013 07:59:34 GMT

Not too sure if I understand your problem correctly, but have you tried using Set Analysis to try and solve it?

i.e. Something like:

NumericCount({$<Year={$(='2011')}>}ArticleNo)

Hope this helps.

Re: Dimension expression shows repetitive values.

Gysbert_Wassenaar — Wed, 18 Sep 2013 08:06:05 GMT

It's probably because the values in your Time_interval dimension are not actually identical. Without looking at your data it is impossible to tell what's wrong. Please post a sample document that demonstrates the problem. See this document: Preparing examples for Upload - Reduction and Data Scrambling