Values Null on Script Qlikview

[Fanch]

Hi Everybody,

I need to build a historic table by An QlikView Script 🤔.

My script begin like this :

And the results :

But i want to have a result like this with the value 0 that replace the character  "-" : 

I've tried this     without success 🙄

The script show me a issue "Invalid Expression" 🤕

Can you help me ?

Thanks,

Fanch

[agigliotti]

Hi @Fanch ,

Maybe you can try with:

Count( Distinct Alt(HARDWARE, 0) ) AS CNT_WINDOWS

I hope it can help.

Best Regards

[Fanch]

Hi agigliotti,

Thanks for your help, but i always have the same issue even with the try :

Alt( Count(distinct MATNUM)), 0) 🤔

[MayilVahanan]

HI @Fanch 

I think, country2 doesn't have OS like windows. In that case try like below,

T:
Load * Inline
[
Country, Hardware, OS
1, 20, Windows 10
2,30,Linux
3, 35,Windows 9
];
Join
Load Country, Count(DISTINCT Hardware) as CNT Resident T where OS like '*windo*' Group by Country;

Final:
NoConcatenate
Load Country, Alt(CNT,0) as CNT, Hardware, OS Resident T;
DROP Table T;

Change the column & table name based on ur source;

[Ksrinivasan]

hi,

My dummy data:

DIM: NAME_COUNTRY,

MEASURE: Sum(If(WildMatch(CNT_WINDOW,'*WINDOW*'),1,0))

ksrinivasan

[Fanch · Accepted solution]

Hi everybody,

Find the solution and, for me, it's better to do like this. 

After Load TABLE_HISTO, i build a another table :

Thanks to Agigliotti, MayilVahanan and Ksrinivasan 😎

Have a nice day !