Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Dimension expression shows repetitive values.

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
2 Replies
kangaroomac
Contributor II

Re: Dimension expression shows repetitive values.

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.

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


talk is cheap, supply exceeds demand
Community Browser