topic Re: Generate fixed data automatically and insert a row in QlikView

Generate fixed data automatically and insert a row

Yuhka — Sat, 16 Nov 2024 03:46:51 GMT

Hello everyone, I'm new to qlikview.

I have data which has columns : Name, Date, Subject and Score.

On my qvw, I created a pivot table which dimention is Date and showing the score by the subjects of each person.

Then, now I would like to insert a row as below.

With the assumption:

- I cannot fix the source data.

- "Date: Friday", "Subject: computer science" and "Score: 100" is a fixed value. Whatecer I select in the listbox, the value should be the same.

Is there any way to do this?

Thank you for your support!

Re: Generate fixed data automatically and insert a row

arpitkharkia — Wed, 24 Apr 2019 06:35:06 GMT

You can concatenate an inline table with the required values to the imported table.

I hope this makes sense. Let me know if there is still any confusion.

Thanks!

Arpit

Re: Generate fixed data automatically and insert a row

Yuhka — Thu, 25 Apr 2019 01:58:48 GMT

@arpitkharkia, thank you for your quick reply.

I tried concatenate inline, but it didn't go well.

In case to load inline the values "Date: Friday", "Subject: computer science" and "Score: 100", the row is added but Name column becomes null as below.

Then I select something in the Name listbox, due to this record is not apply to the selection so the row of computer science is not shown in the pivot table.

Only when nothing is selected, the row is shown on the pivot table.

Re: Generate fixed data automatically and insert a row

arpitkharkia — Thu, 25 Apr 2019 05:52:02 GMT

There are three rows that you will need to add, one for each of the names.

I hope i make sense. Let me know if there is still any confusion.

Regards,

Arpit

PFA

Re: Generate fixed data automatically and insert a row

Yuhka — Thu, 25 Apr 2019 06:40:59 GMT

Arpit san, thank you for your answer.

Sorry for confusing you. I'm looking for the way to generate the record without inputting Name manually.

Currently the Name is only three kinds, but I have to create qvw assuming the possibility of increase or decrease of the Name.

So what I would like to do is always showing the row of "Dat: Friday"-"computer science"-"Score: 100" whatever I select in the listbox.

Thank you very much for your support!

Re: Generate fixed data automatically and insert a row

Vengatesh — Thu, 25 Apr 2019 07:18:05 GMT

Try this

Source:
LOAD Name,
Date,
Subject,
Score
FROM
[Score.xlsx]
(ooxml, embedded labels, table is Sheet1);

Concatenate
LOAD Distinct Name,
'Friday' as Date,
'Computer Science' as Subject,
100 as Score

Resident Source;

Re: Generate fixed data automatically and insert a row

Yuhka — Thu, 25 Apr 2019 08:06:15 GMT

@Vengatesh , thank you for your answer!

It worked perfectly! Thank you very much for your support!