- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Passing the first dimension to Aggr function or Total function in set in pivot chart ?
Hii folks,
Suppose i am having 3 dimensions in a pivot chart as zone,region,branch and i m show sum(sales) as expression.
Now i want to add another expression - something like
aggr(NODISTINCT sum(Sales),(FirstDimension))
or
sum(TOTAL<FirstDimension> Sales)
i.e if Zone is the first dimension of the chart output should be zone wise totals , if users drags the dimension and makes region as the first dimension in the chart then output should be Regionwise totals.
Is this possible ?
Any help would be appreciated.
Thanks,
Rohan
- Tags:
- aggr
- aggr total
- column number
- getobjectfield
- grand total
- new_to_qlikview
- pivot table totals
- total
- totals-dimension
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello both,
i finally found a dynamic solution to this requirement without the use of input box or variables -
sum(TOTAL<$(=GetObjectField(0,'CH24'))> Sales)
or
aggr(NODISTINCT sum(Sales),$(=GetObjectField(0,'CH24')))
Thank you for your solutions as well.
Regards,
Rohan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I don't think this would be possible. A not so efficient work around would be to have overlapping charts which hide show based on button may be where each chart have one of the dimension as the first dimension.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Agreed with you Sunny...
But one thing, If this scenario comes in Adhoc Reporting, where user will be picking the dimension you dont think using variables and FieldSelection combination and we can make it dynamic.
I mean to say, I am putting the First selected value of dimension into a variable and then using that variable in grouping..
Is this not possible?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It might work. Will have to be tested out.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am having Adhoc reporting itself , and in the scenario mentioned by you what if a user selects more than 1 dimension in adhoc , in such case how will qlikview identify which is the first selected Dimension that should be passed to the variable ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think, this is what Rohan is asking..
As per him
i.e if Zone is the first dimension of the chart output should be zone wise totals , if users drags the dimension and makes region as the first dimension in the chart then output should be Regionwise totals.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yes u are correct balraj.
What i want is something like -
aggr(NODISTINCT sum(Sales),getobjectfield(0)))
-GetObjetcfield(0) gives me the name of my first dimension,however i am not able to pass it to AGGR fuction as a dimension.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I guess you were right. It can work. Try it out Rohan Rane
Selection in vDim1 will drive the output of the second expression here (=Sum(TOTAL <$(vDim1)>Value))
Thanks balrajahlawat for forcing me to reconsider.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Did not force you. Just shared my thoughts with you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Your thoughts forced me to reconsider , how about that?
- « Previous Replies
-
- 1
- 2
- Next Replies »