Discussion Board for collaboration on QlikView Scripting.
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.
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:
Hope this helps.
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