Solved: Queries regarding the sample model. - Qlik Community

suvechha_b · ‎2016-04-25

Hi ,

I have attached the sample model.

I have some queries regarding the model.

1.In the diagram , why the PREVIEW is inactive.

2. I have got I value in SPPrice . See the screenshot .

3. I cannot find out from where the null SEP is coming.

Please assist.

Sample qlikview model attached.

MindaugasBacius · ‎2016-04-25

SPPrice table is connected with Transactions table.

The SPPrice table misses the SEP values for key - prucuct_key & TransDate.

See the picture below:

View solution in original post

PrashantSangle · ‎2016-04-25

Hi,

check do you have SEP value on Trans Date

20160404

20160405

20160413

20160414

Note: Avoid synthetic table if you can.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

MindaugasBacius · ‎2016-04-25

SPPrice table is connected with Transactions table.

The SPPrice table misses the SEP values for key - prucuct_key & TransDate.

See the picture below: