topic Re: need help in QlikView

need help

NavinReddy — Wed, 26 Apr 2017 15:11:44 GMT

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

Re: need help

Anil_Babu_Samineni — Thu, 27 Apr 2017 00:59:58 GMT

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

Re: need help

NavinReddy — Thu, 27 Apr 2017 09:12:09 GMT

Hello Anil,

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

Regards,

Niranjan

Re: need help

NavinReddy — Tue, 02 May 2017 14:36:05 GMT

Dear Experts,

Any Suggestions please.

Many Thanks,

Niranjan

Re: need help

Anil_Babu_Samineni — Tue, 02 May 2017 14:47:23 GMT

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.

Re: need help

NavinReddy — Tue, 02 May 2017 15:33:26 GMT

Hi Anil,

Thanks for your reply,

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

Thanks,

Niranjan

Re: need help

prieper — Tue, 02 May 2017 15:43:00 GMT

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

Re: need help

Anil_Babu_Samineni — Tue, 02 May 2017 15:57:32 GMT

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‌

Re: need help

NavinReddy — Tue, 02 May 2017 16:36:12 GMT

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

Re: need help

sunny_talwar — Tue, 02 May 2017 16:55:19 GMT

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

Re: need help

Clever_Anjos — Tue, 02 May 2017 17:07:10 GMT

as long as I can see it´s not possible using a regular pivot table

A similar solution could be

Convert BenchMark into dimension
Convert "Target Limit" into dimension
Remove EID dimension
Use "Ident mode" under Style tab

Re: need help

neelamsaroha157 — Tue, 02 May 2017 17:12:03 GMT

Are you looking for something like this.

Re: need help

NavinReddy — Wed, 03 May 2017 09:35:48 GMT

Thank you so much Clever so how i can manage with this solution

Re: need help

NavinReddy — Mon, 08 May 2017 10:15:12 GMT

Hi Clever,

For all functions its displaying subtotals. Can you please suggest me how could we disable subtotal for function.

Thanks in advance

Niranjan