Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am new to the QlikView and I am trying to develop a report that shows the past month's usage count while needs to display the year to month count as well. The sample tables structure are as below
Output would be something like the following:
I try to accomplish this with IF statement but the performance is very very slow.
Additional info
Any other formula can achieve this?
Thanks[:)]
Take a look at what I add, maybe this is a solution for you:
Hi Dennis,
I got what you mean now. Thanks for your sample.
Btw, by using your method, the output is slightly different from mine because the break down of the latest month is missed. Any idea to achieve this? I tried several ways but no luck at all.
Thanks
Sorry made a paste and copy mistake in the expression
It should be:
count (distinct readcontactid) + count (distinct createcontactid)
(not : count (distinct readcontactid) + count (distinct readcontactid) )
Hi Dennis,
Yes, I noticed that and I had made the change already.
But in my previous post, as I mentioned, by puting the YrMth as the another dimension on top, the break down for the LATEST YrMth (I just want to show the break down for LATEST MONTH ONLY) is missed. Can this be achieved?
Thanks
Sorry I don't get it.
What do you mean by a break down?
Hi Dennis,
I attached the excel screen shot in my question. There are ReadCount and CreateCount field just next to UserName. These 2 fields are the break down for the Jan11 total.
ReadCount + CreateCount = Jan11
Thanks
Is this what you are looking for:
Count({$<YrMth={$(=Max(YrMth))}>} DISTINCT readcontactid)
+
Count({$<YrMth={$(=Max(YrMth))}>} DISTINCT createcontactid)
Hi Dennis,
Thanks again but this is not what I want.
The requirements for a single pivot table are:
Hope this clear.
Thanks