Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
paullawrence190
Contributor
Contributor

Cross over table with Flags

Hi

I want to take some data in a cross over table and put some flags on it.   The flags work fine when not crossover but fail when I convert to crossover.  Is there any ay to make this work please.  Data is coming form a spread sheet that is fed out of Sage so I cant alter it easily.

Thanks

Paul

Simple table:

LOAD
Client,
Code,
Jan,
Feb,
Mar,
Apr,
May,
June,
if(WildMatch([Code],'*1001*') and WildMatch([Code],'*Revenue*'),1,0)  as MSKTriageFLag

Cross:


CrossTable(Date, Data, 2)
LOAD Client,
Code,
Jan,
Feb,
Mar,
Apr,
May,
June,

if(WildMatch([Code],'*1001*') and WildMatch(

,'*Revenue*'),1,0)  as MSKTriageFLag

5 Replies
Frank_Hartmann
Master II
Master II

try like this:

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='#.##0,00 €;-#.##0,00 €';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD.MM.YYYY';

SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';

SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';

1:

LOAD Client,

     Code,

     Jan,

     Feb,

     Mar,

     Apr,

     May,

     June

FROM

[227208.xlsx]

(ooxml, embedded labels, table is Tabelle1);

2:

CrossTable(Date, Data, 2)

LOAD Client,

     Code,

     Jan,

     Feb,

     Mar,   

     Apr,

     May,

     June

FROM

[227208.xlsx]

(ooxml, embedded labels, table is Tabelle1);

Load *,

if(WildMatch(Code,'*1001*'),1,if( WildMatch(Code,'*Revenue*'),1,0))  as MSKTriageFLag

Resident 2;

DROP Table 2,1;

MarcoWedel

maybe like

CrossTable(Date, Data, 3)
LOAD Client,
Code,

if(WildMatch([Code],'*1001*') and WildMatch(

,'*Revenue*'),1,0)  as MSKTriageFLag,

Jan,
Feb,
Mar,
Apr,
May,
June



hope this helps


regards


Marco

vinieme12
Champion II
Champion II

Do a cross tab of your resident simple table

TAB_SIMPLE:

LOAD
Client,
Code,
Jan,
Feb,
Mar,
Apr,
May,
June,
if(WildMatch([Code],'*1001*') and WildMatch(

,'*Revenue*'),1,0)  as MSKTriageFLag

Cross:

CrossTable(Date, Data, 3)
LOAD Client,
Code,

MSKTriageFLag,

Jan,
Feb,
Mar,
Apr,
May,
June

RESIDENT TAB_SIMPLE;


Drop Table TAB_SIMPLE;

paullawrence190
Contributor
Contributor
Author

Thanks this is perfect I thought it was going to need a Resident table but was not sure how to do it.

oknotsen
Master III
Master III

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .

May you live in interesting times!