Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Madhab77
Contributor III
Contributor III

creating new fields

Hi All

I have the following input table and I need to have the second table as the output, could you please suggest any solution to achieve this. 

Madhab77_0-1609248126443.png

 

 

Thanks in Advance.

Labels (1)
1 Solution

Accepted Solutions
Anil_Babu_Samineni

You mean like this, PFA

2020-12-29 16_27_26-QlikView x64 - [C__Users_ansam3_Documents_QS Community_QS_Comm_Help_M177142.qvw].png

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

3 Replies
Anil_Babu_Samineni

You mean like this, PFA

2020-12-29 16_27_26-QlikView x64 - [C__Users_ansam3_Documents_QS Community_QS_Comm_Help_M177142.qvw].png

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Madhab77
Contributor III
Contributor III
Author

Hi Anil,

Thanks for you suggestion. Unfortunately, it was not my exact expectation. Your solution gave value for all the months, but my requirement is that the value should be populated for all the months which are From Start_Date to End_Date.

Thanks Anil, for you effort, which you put in for me.

Anil_Babu_Samineni

Change your initial post and update us to track, I see that your expectation is similar as per image? If you need full, You can simply use Sum(value)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)