new to qlikview

[srujanaponnuru]

Hi,

Please help me to resolve this issue.

I have the data in excel. when I click on month wise data , in my text box, I should get only that month data in text box.

I have given the expression as:

=Concat(chr(9679) & ' ' & [Production Quality] & Chr(10),chr(10),PID)

But when i click on may month, I am able to see june and july data as well. But I need only may first 3 lines to appear ion text box.

Pleae help me.

Attached is my excel data.

[kaushiknsolanki]

Hi,

The expression works well.. When I selected May month it shows me those 3 lines.

Can you share your application.

Regards,

Kaushik Solanki

[srujanaponnuru]

my qvw is attached. using master calendar it is not working.

[sunny_talwar]

I think your data model is not well connected. There is no link between MasterCalendar and any other table including ProductionQuality table. Any selection in Month field will have no impact on anything else in the dashboard unless you connect them one date of MonthYear in your case

[srujanaponnuru]

how do we do that ?

[sunny_talwar]

May be create a new field in your Product Quality table:

LOAD PID,

          PQ_Year,

          PQ_Month,

          Date(MakeDate(PQ_Year, PQ_Month, 1), 'MMM-YYYY') as MonthYear,

          Production Quality

FROM ....

[srujanaponnuru]

I tried this, but it is not working. Is there any other way to do >

Could you please let me know . thank u

[srujanaponnuru]

I tried this, but it is not working. Is there any other way to do >

Could you please let me know . thank u

[sunny_talwar]

The data model doesn't show them to be connected after you make the change?