Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
Is there any way can i make one function for list of discriptions in Qlikview. i tried with pivot table.
Please find the below imagae look like i want to impliment in Qlikview.
please suggest me if any ideas
Thanks in Advance,
Niranjan
as long as I can see it´s not possible using a regular pivot table
A similar solution could be
We can achieve same, Is that possible to share sample data
Hello Anil,
Sorry for my late reply, please check i have attached sample data.
Regards,
Niranjan
Dear Experts,
Any Suggestions please.
Many Thanks,
Niranjan
Try promote to the first place of Function. And then use Partial sum for Function and give the Name for Sub total called =Function then look how it is.
Hi Anil,
Thanks for your reply,
i tried as you said but i just want to disply function on top of description.
Thanks,
Niranjan
Not quite clear, what you wish to achieve.
The above is a list of your KPI's and you wish to have the categoriy (Dealer commercail service, Dealer monitoring) as field in your table?
Then try something like
LOAD
*,
IF(LEN(TRIM(id)), PEEK(Cat), Description) AS Cat;
LOAD * INLINE [
id, Function, Description
, , Dealer
1, f1, asdfsdj
2, f2, bla bla
3, f3, bla bla bal
, , D Monitoring
4, f4, Bla 4
5, f5, Bla 5
];
In a second go you may then eliminate the blank id's.
HTH Peter
In built partial sum returns with Data as well. I doubt, Whether it will work as you need. Let's wait for response
marcowedel stalwar1 cleveranjos
Hi Peter,
Thanks for your reply,
i just want to disply function on top of description.
i have only one function for list of descriptions. i have to create a chart like one function under associated desctions for the function.
Sorry for my bad explanation.
Many Thanks,
Niranjan
May be vinieme12 can throw some light here since he has created this amazing blog here: Partial Sums in straight table | Custom Labels in Pivot SubTotals