topic Re: Peek Function in Qlikview in QlikView

Peek Function in Qlikview

shanu_s9 — Wed, 25 Nov 2020 16:16:04 GMT

Hi experts,

I am new to qlikview,

i have data like

Month,Sales Volume

March,2145

April,2458

May,1245

June,5124

July,7421

August,2584

September,5314

October,7846

November,6532

December,4625

January,8547

February,3265

But i want to get values of Sales Volume based on Month.

when Month is equal to May then what is the value in Sales Volume. Can we get through Peek

i was tried Peek('Sales Volume',3) as Sales, then i got 1245.But i don't know in which row is having May in Month column

Please tell me.

Thanks

Re: Peek Function in Qlikview

Anil_Babu_Samineni — Sat, 21 Jan 2017 19:58:32 GMT

when Month is equal to May then what is the value in Sales Volume - What does mean here?

Can you let us know your expected to see from above data

Re: Peek Function in Qlikview

swuehl — Sat, 21 Jan 2017 20:08:33 GMT

In the front end, e,g, in a text box, you can use

=Sum( If(Month ='May', [Sales Volume]))

Sum({<Month = {'May'}>} [Sales Volume])

In the script, you can maybe use a lookup() function:

Let vMaySales = Lookup('Sales Volume','Month','May','YourTableName');

Re: Peek Function in Qlikview

vinieme12 — Sat, 21 Jan 2017 20:09:57 GMT

FACT:

Load * inline [

Month,Sales

March,2145

April,2458

May,1245

June,5124

July,7421

August,2584

September,5314

October,7846

November,6532

December,4625

January,8547

February,3265

];

SaleforMay:

LOAD Sales RESIDENT FACT

WHERE Month = 'May';

Let vMaySales = Peek('Sales',0,'SaleforMay');

Re: Peek Function in Qlikview

shanu_s9 — Sun, 22 Jan 2017 05:33:54 GMT

Hi Vineeth,

Thank you, i got solution.

Re: Peek Function in Qlikview

shanu_s9 — Sun, 22 Jan 2017 05:35:01 GMT

Thank you Stefan for your response.

But i want to get the result through peek.