need help

[NavinReddy]

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

[Anil_Babu_Samineni]

We can achieve same, Is that possible to share sample data

[NavinReddy]

Hello Anil,

Sorry for my late reply, please check i have attached sample data.

Regards,

Niranjan

[NavinReddy]

Dear Experts,

Any Suggestions please.

Many Thanks,

Niranjan

[Anil_Babu_Samineni]

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.

[NavinReddy]

Hi Anil,

Thanks for your reply,

i tried as you said but i just want to disply function on top of description.

Thanks,

Niranjan

[prieper]

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

[Anil_Babu_Samineni]

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‌

[NavinReddy]

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

[sunny_talwar]

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