Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Fanch
Partner - Creator
Partner - Creator

Values Null on Script Qlikview

Hi Everybody,

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

My script begin like this :

Capture1.JPG

And the results :

Capture2.JPG

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

Capture3.JPG

I've tried this  Capture4.JPG   without success 🙄

The script show me a issue "Invalid Expression" 🤕

Can you help me ?

Thanks,

Fanch

1 Solution

Accepted Solutions
Fanch
Partner - Creator
Partner - Creator
Author

Hi everybody,

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

After Load TABLE_HISTO, i build a another table :

Capture5.JPG

Thanks to Agigliotti, MayilVahanan and Ksrinivasan 😎

Have a nice day !

 

View solution in original post

5 Replies
agigliotti
Partner - Champion
Partner - Champion

Hi @Fanch ,

Maybe you can try with:

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

I hope it can help.

Best Regards

Fanch
Partner - Creator
Partner - Creator
Author

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;

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Ksrinivasan
Specialist
Specialist

hi,

My dummy data:

Ksrinivasan_0-1614242381344.png

DIM: NAME_COUNTRY,

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

Ksrinivasan_1-1614242435904.png

ksrinivasan

 

 

Fanch
Partner - Creator
Partner - Creator
Author

Hi everybody,

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

After Load TABLE_HISTO, i build a another table :

Capture5.JPG

Thanks to Agigliotti, MayilVahanan and Ksrinivasan 😎

Have a nice day !