Area for people to learn more about current Qlik related job postings.
Data is mentioned in the above table. my requirement is to display separate month columns like jan
feb ........ in output table . plz send me solution.
THE .QVW FILE NOT OPEN IN MY PERSONAL PC SO PLZ EXPLAIN ME
You may have to use loop to separate month in each row.
FOR i = 1 to 3
SubField(Month, ',', $(i)) as Month
Name, Time, Month
raju, 11:30, "jan,feb,march"
suresh, 12:30, "april,may,june"
rajesh, 1:30, "july,aug,sept"
mahesh, 10:30, "oct,nov,dec"
My answer is the same with Satyadev below.
For condition is not needed i guess.
Simple subfield will work fine
SubField(Month, ',') as Month;
LOAD * INLINE [
Try closing the discussion by choosing the right answer, which might be useful in future for the one, who comes in and searches for the same question
Try like this
SubField(Month, ',') as Month