Peek Function in Qlikview

[shanu_s9]

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

[Anil_Babu_Samineni]

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

[swuehl]

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

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

or

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

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

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

[vinieme12 · Accepted solution]

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');

[shanu_s9]

Hi Vineeth,

Thank you, i got solution.

[shanu_s9]

Thank you Stefan for your response.

But i  want to get the result through peek.