Issue with number format - calculated column

[da_pagnott]

Hello guys,

I'm stucked with an issue with a number that Qlik see as text i think, and I can't go on with my analysis.. Could you please help me?

I add a new calculated  column to my table as below:

Num(
if([DATA DA ASSEGNARE]-DATARICEZIONEORDINEMAG>0, NetWorkDays(DATARICEZIONEORDINEMAG,[DATA DA ASSEGNARE])*1
,0)
*1)

Qlik recognize it as dimension and not as measure, even if I change it form the settings when i save/reload it comes back to dimension instead of measure.

So when i try to sum or use this value in my dashboard I always get 0 as result..

Do you have any idea please?

Thank you very much!

[Uday_Pasupuleti]

Try Num#()

[da_pagnott]

I already tried but it doesn't work..

[Uday_Pasupuleti]

If you can upload a sample data set then I might able to figure it out.

[da_pagnott]

Yes of course!

Please find attached a sample, the column is the last one, named "TEST".

The colums TEST should be similar to TEST2 one, but Qlik see TEST as dimension and TEST2 as measure.

Thank you very much, really!

[Uday_Pasupuleti]

Could you send the actual file?

I can't use external qvf.

[da_pagnott]

Waht do you mean for actual file?

[Uday_Pasupuleti]

txt or excel file

[da_pagnott]

Here you are!

[Uday_Pasupuleti]

You have sent me the output file.. I would like to see the values of the actual fields so that I can try to test with different expressions.

Try to num# each of the fields rather than wrapping whole if statement in num#